Maintaining unique CustomerID with multiple purchases

[NER]

Hello,



I am trying to make a basic database system to track orders and contacts and the like for my small business. I have created a series of databases that look pretty standard, something like this example:


I want to create a form that I will open and complete every time I process an order. I want to fill out both the customer info and the order details at one time.

Assuming that the "CustomerID" in the "Customers" table is set to Autonumber in order to create a unique ID, how do I keep from creating multiple new "customers" every time I enter a new order regardless of whether or not that customer already has an ID number from a prior order?

It seems that I would need to make some sort of Macro that would say something like, if the "CompanyName" entered is already listed in the 'Customer' table, use the existing CustomerID, if it is not listed in the Customer table create a new CustomerID.

I'm obviously new to databases but am slowly stumbling along. Can someone help point me in the right direction. Should I be looking into Macros, and if so should the macro be built into the form or the database? Is there another better solution to what seems like it would be a pretty common problem?


Please move post if this should be in the Macros Forum.

-Thanks

[Bob Fitz]

Perhaps this earlier post will help: https://www.accessforums.net/databas...orm-22220.html