Duplicates

  • Thread starter Thread starter Chris Kennedy
  • Start date Start date
C

Chris Kennedy

Is there an easy way to prevent duplicate in a non primary key table.
 
Yes, set an index on the field and set the index for No Duplicates. To do
this, open the table in design view, click on the field, and go to the
dialog at the bottom of the window. One of the options is "Indexed", set it
to "Yes (No Duplicates)".
 
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

Duplicate values 4
Best Gmail Backup Tool to use in 2025? 3
Duplicate values in the index, primary key, or relationship messag 2
Copy or Duplicate Record Woes 3
Avoiding Duplicates 1
duplicate value error message - new issue 1
Adding a primary key 3
Why can't a primary key be duplicated? 5

Back
Top