customer is placing a order, already a customer, if not add then proceed with order

[Joanne Campbell]

Hi
Very new to Access 2007. I am creating this database for a company that takes orders over the phone. I do get a lot of repeat customers. I have created all my tables, Customers, Orders, Products, payment method etc. When a customer phones in to place an order. Now I want to be able to 1. check if the customer is in the system 2. If they are not add them to the customer table and continue taking the order 3. If they are in the system,be able to see all of their past orders but most importantly auto fill the order form with their customer information. Can this all while I'm on the oder form? Where shall I start?

[orangeCat]

How do you intend to identify a customer?
Do you record a phone number?
Do you record an address?
Do you record the Zip?

You could check for phone number and zip

Check for DCount( parms ) > 0
If present, customer exists
If not present, customer doesn't exist