Duplicate records

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
 
G

Graham Mandeno

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.
 
J

John Vinson

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.
 
Top