I need to add an surrogate key to a view

[katora]

ok, thanks I understand what you are saying. I will look at the view again. thanks