One Form to add to two tables

[Skip Bisconer]

Is it possible to use one form to add records to two different tables that have a linked field? Or do I have to make two different forms?

I have an Assigned Order table and Assigned Order Lines table with the order number as a common field. These tables are updated the previous end of business with new data from the server through another process but many times we come accross what we call a late order (a must deliver today) and have to add it to the access tables to make all the reports accurate for the days deliveries. I appreciate any suggestions.

 

[CEH]

Your question is a little confusing.... What on the server is entering info into your tables? If your form is built on a query of both tables it will add info to both tables.

 

[Skip Bisconer]

Thanks for responding Curtis:

I have an Order Header table with customer information and an Order Line table. I would like to beable to basically create and invoice (form) that would add the order and customer information to the Order Header table and add lines of product on the form which would add to the Order Line Table. I hope this is clearer to you. The server part I mention updates these tables with data daily but the download is made in the evening. I need to beable to add late orders to these two tables. A late order is one which came in today for shipment today so it needs to be in the tables in order for the dispatcher to assign it to a delivery truck report for the driver. I hope this makes more sense.