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