Prevent Duplicate Names

[scjohn]

Can you help me with vb code so that if a customers name already exist in the customer table, they would recieve a message not to enter thier name and to move on to the next screen.

 

[scjohn]

Im not very good writing vb code, i know this isnt very difficult but i cant figure it out. I want to be able to stop customers from entering in thier name if it already exist in the database. i know it would be a comparefunction but not sure how to do this. please help.

 

[meboz]

Place a unique index on the table in the customer name column

If you want to allow duplicates in First Name or Surname, create a composite index and force uniqueness