<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.