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

  • Thread starter Thread starter Cat364
  • Start date Start date
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking records to auto complete information 1
Auto create of new record when accessing subform 3
Same record/Primary key in multiple tables 0
Updating tables when you input new data 0
Data Entry Form and Auto Number ID 2
Edited data record to be inserted as a new data record under the same PO number in Microsoft Access 0
how to create new record automatically 2
Identify and display duplicate records 0

Back
Top