append Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query which determines components I need to buy for a project. I
would like to append the information to a table named "TblOrderDetails".
This table, however, is linked to another table named "TblOrders", in a one
to many relationship, so that each record in "TblOrderDetails" is linked to a
single record in "TblOrders" which contains supplier info, PO number, et
cetera. How can I add one new record to "TblOrders", then append my query
infor to "TblOrderDetails", and maintain the link?
 
Thanks Chris,
What I am not sure about though, is how to append the linking field for
"TblOrderDetails". In other words, first I create one new record in
"TblOrders" with the first query. The primary key is an autonumber field,
and so will be filled in automatically. When I run the second query however,
it will need to know what that field is, so that it can be entered into the
"many" side of the relationship... how can I do that?
 
Back
Top