SQL issue , How to insert multiple rows into two tables

[john96113]

Hey, I am a NEW comer, I try to write a ASP with DB-MS-Access, I encounter trouble,

Table 1 (order table)

OrderNo, CustomerNo.
1 011
2 033
3 023

Table 2 ( DetailOrder)

OrderNo, ItemNo, itemDescription
: : :
3 111 car
3 112 truck

-- For example customer 023 order 111 and 112 in OrderNo 3
Please help me how to write this SQL to put data order 3 in to both tables at same time with INSERT, Thank you very much.

 

[swampBoogie]

Don't crosspost. It is sufficient to post in the MS access forum.