Help with append query

[Kim]

Please help me to write an append query that will append records from one
table to multiple tables that have an inner join operation

Thank you

 

[Allen Browne]

Kim, you may not be able to do this with a single query. The simplest way to
do this might be by executing a series of append queries.

For example, if you are trying to append the records to an Orders table with
an OrderID primary key, and also the OrderDetail table (for the line items
in the order), you need th new OrderID primary key value from appending to
the Orders table so you can use it in the related table. You can't do that
with a single operation.