Stop duplicated data

[Simon]

I have a database that i use for placing order from my company website.

When i get a order i add the customer details and then type in the
products they have entered

As i am now getting repeat cusomers is there a was for when i enter a
new customer it can check that i do not have that customer on recored
already.

Could you one recomened the best way to do this

Thanks

Simon

 

[John Vinson]

I have a database that i use for placing order from my company website.

When i get a order i add the customer details and then type in the
products they have entered

As i am now getting repeat cusomers is there a was for when i enter a
new customer it can check that i do not have that customer on recored
already.

Could you one recomened the best way to do this

You should certainly have separate tables for Customers and Orders;
the customer information should be stored once, and once only. You'ld
use a Combo Box on a Form to enter the CustomerID into the orders
form.

Take a look at the Northwind sample database for an (imperfect)
example of how this can be done.

John W. Vinson[MVP]