Just found more good info on @@IDENTITY.. I apologize if these links were already covered.. just thought there might be an interest. http://www.sqlteam.com/item.asp?ItemID=319 -----Original Message----- From: Ryan Mayberry [mailto:Ryan at applicor.com] <tip> I think there was a thread in the last couple of days about inserting into more than one tables and how to access the value of an identity field after inserting a record that must be referred to in subsequent inserts. I just ran into the need for this today and one of my co-workers sent me this. Thought I would share. http://www.aspwatch.com/c/200017/d723A6FA449DE11D3ADB000A0C9E95208.asp It's ASP, SQL Server specific </tip> -- VP Technology Applicor Inc. --------------------------------------- For unsubscribe and other options, including the Tip Harvester and archive of TheList go to: http://lists.evolt.org Workers of the Web, evolt !