Can I append to 2 different tables?

[Darrell Childress]

I have a database where the salespeople enter general info regarding a
new order. They then click on a button that runs an append query which
appends the data from the current order into a table located in a
separate database. Is there a way that the append query can append data
to 2 separate tables, i.e., some fields would be appended into tblOrders
and some fields would be appended into tblMfgData? I don't think that's
possible, so if not, how can I accomplish this? Would I need to create a
button that runs 2 distinct append queries - one to append data into
tblOrders and another to append data into tblMfgData...or is there a
better/easier way to do this?

Thanks for any help,
Darrell

 

[Marshall Barton]

I have a database where the salespeople enter general info regarding a
new order. They then click on a button that runs an append query which
appends the data from the current order into a table located in a
separate database. Is there a way that the append query can append data
to 2 separate tables, i.e., some fields would be appended into tblOrders
and some fields would be appended into tblMfgData? I don't think that's
possible, so if not, how can I accomplish this? Would I need to create a
button that runs 2 distinct append queries - one to append data into
tblOrders and another to append data into tblMfgData...or is there a
better/easier way to do this?

Use two append queries. Sounds simple enough to me, why do
you think its not? There may be a way to do it with one
query, but it would be more complicated, subject to changes
in the undocumented behavior and incompatible with other
database systems.

 

[Darrell Childress]

Thank you, Marshall. I agree that's a simple solution. I actually didn't
think of it until I was writing my question, but I decided to go ahead
and post the question just to make sure there wasn't a simple all-in-one
solution.
Thanks again,
Darrell