duplication of the customer name ?

  • Thread starter Thread starter lalexander
  • Start date Start date
L

lalexander

I have a customer form that has

custid
custname

Is there a way to prevent a duplication of the customer name ?
 
Go back to the table the form is based on. For the CustName field, set the index
to Yes, No Duplicates. An error message will popup if a duplicate name is
entered. Trap that error with your own message.
 
Open the underlying table in design view and set a "No Duplicates" index
on the custname field.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Acceptable condition to break normalization rules? 9
how to have a form that generate invoice no. 2
Access Auto Matching Duplicates? 0
SQL help needed please 5
Sorting and Filter in Multiple Sheets using Hyperlinks 2
return primary key for record after append query 3
Help with a query design 1
Form design to add data to 3 tables in "Order Entry" style db 1

Back
Top