Customer look UP

[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

 

[srbond]

What I would do is one of two things:

1. Make your customer field on the form a dropdown, so that when entering an
order you can see if the customer exists... and choose it if it does

and/or

2. Set the customer field in the customer table index propert to "YES NO
DUPLICATES"

 

[John Vinson]

What I would do is one of two things:

1. Make your customer field on the form a dropdown, so that when entering an
order you can see if the customer exists... and choose it if it does

and/or

2. Set the customer field in the customer table index propert to "YES NO
DUPLICATES"

Just DON'T use the customer name in this index!!!! Names are NOT
unique; you very well might get two customers who both happen to be
named Jim Smith.

John W. Vinson[MVP]