I'm looking for advice on the best way to write foreign key information to a second table on SQL Server after successfully appending a record to a first table. One of the foreign keys in the second table is generated at the time the data is added to the first table, and I need a way to capture that key information and put it in the second table.

Thanks,