Is there an easy way to prevent duplicate in a non primary key table.
C Chris Kennedy Aug 27, 2005 #1 Is there an easy way to prevent duplicate in a non primary key table.
W Wayne Morgan Aug 27, 2005 #2 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)".
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)".
