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
>