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
>>