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.