Posted by t8ntboy on 01/30/08 21:18

ASP/SQL Server Express 05

I have two tables, A and B. I would like to insert multiple records
into both form A and B, but a field in form B is the Record ID in form
A. So, I need to insert the records into A, collect the ID and then
insert into B. I have no problem doing this for individual records;
I am not sure what the best way to this is for multiple records being
inserted at the same time.

How would you accomplish this if you were me?

Any help would be appreciated tremendously.

• Next in forum: Avg() not including 0's
• Prev in forum: Create Table with Variable included in Table Name
• Thread view: Inserting multiple records into two tables...with a twist

[Reply to this message]