New Record

[SMERTZ]

I have a very simple table structure
Table one customer
Table two orders

One customer to many orders

So I want to create a form to enter new orders, based on the customer name
or ID. So my question is how do I go about getting the customer last name
or Customer Number and then adding an order to the order table with the
customer info auto filled out for me..

thanks

 

[Van T. Dinh]

The sample database "NorthWind" that comes with your Access software has
exactly what you need.

 

[LeeLi]

Hi,

you may use relationship to link this two table up. so whatever info you
enter in Customer table and will automatically update Order table as well.