Data access page - more than auto update in new record. Help!

C

Cat364

I am on the berge of starting my own business and am new to Microsoft Access.

As I am quite conversant with Excel I have managed to create a database
including cusrtomers, orders, payments etc.

However, having brought the necessary information together into a data
access page, when I create a new record both the Order and Customer IDs
update, when I only want the Order ID to.

It may be something really simple, but any help will be greatly appreciated.
 
P

Pat Hartman

If you don't want a new customer to be added, you need to supply the ID of
the customer record you want to reference.
 
Top