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...