Duplicate records

  • Thread starter Thread starter Shirley
  • Start date Start date
S

Shirley

I have a table recording a troubleshooting events. The
date can be entered by mutiple users.

There are a few fileds in this table. Each field can have
duplicate entris, but all together should be unique. Is
there any simple command to check whether the new record
is unique?

Thanks,

Shirley
 
Hi Shirley

You can *prevent* duplicate records from being entered by creating a
composite (multi-field) index in your table comprising all the fields.

To find existing duplicates, you can use a query. The "Find Duplicates"
query wizard will guide you through that.
 
There are a few fileds in this table. Each field can have
duplicate entris, but all together should be unique.
Click to expand...

You can set the combination of up to ten fields as a multifield
Primary Key (ctrl-click the fields in table design view and click the
key icon), or you can use the Indexes tool (looks like lightning
hitting a datasheet) to create a multifield unique Index; either will
prevent the entry of duplicates.
 
Back
Top