Trigger: Update

[pierrecor]

I want to insert a record into table B based after updating a row in table A using the identity key value from table A . I thought I can use a AFTER UPDATE trigger, to no avail, the recordselector moves to the last row in the table after an update. Any help will be appreciated.

Pierre

[ck9663]

I want to insert a record into table B based after updating a row in table A using the identity key value from table A . I thought I can use a AFTER UPDATE trigger, to no avail, the recordselector moves to the last row in the table after an update. Any help will be appreciated.

Pierre

get the record that you will insert into table B from the INSERTED table.