You're welcome. Yes, an extra unique non-changable field will solve this problem.
>the id is the PK, i think i have to add a reference field tht will never change ....
>Anyway a big thanks to you for your times & etcs...
>
>
>>Do you have a PK in your table wich is never changed? If yes, then
>>
>>create trigger tr_Test_Update on Test for update as
>>begin
>> update T set FollowID = I.ID from Test T
>> inner join Deleted Del on T.FollowID = Del.ID
>> inner join Inserted I on I.RealPK = Del.RealPK
>>end
>>
If it's not broken, fix it until it is.
My Blog