Inserting multiple records into two tables...with a twist

From: t8ntboy <t8ntboy@xxxxxxxxx>
Date: Wed, 30 Jan 2008 13:18:26 -0800 (PST)

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

Follow-Ups:
- Re: Inserting multiple records into two tables...with a twist
  - From: Erland Sommarskog
- Re: Inserting multiple records into two tables...with a twist
  - From: Hugo Kornelis

Prev by Date: Create Table with Variable included in Table Name
Next by Date: Avg() not including 0's
Previous by thread: Create Table with Variable included in Table Name
Next by thread: Re: Inserting multiple records into two tables...with a twist
Index(es):
- Date
- Thread

Relevant Pages

Create one record from multiple records
... Can someone please give me some pointers on how to ... accomplish this task? ... I have one table with multiple records. ... dates), add the sum of the charges for a given year (for this example, ...
(microsoft.public.fox.programmer.exchange)
Re: Create one record from multiple records
... accomplish this task? ... I have one table with multiple records. ... dates), add the sum of the charges for a given year (for this example, ... Bernhard Sander ...
(microsoft.public.fox.programmer.exchange)