Allow no dups for EVERY field

[AvalancheMike]

Is there a way to not allow duplicate entries when ALL fields have been
previously entered?
TIA

 

[Rick B]

You would have to make a compound index. While in table design view, click
VIEW then INDEXES. You can enter several fields (one after the other) to
create a compound index and then set the unque property.

It would look something like:

INDEX NAME FIELD NAME
UniqueRecord Field1
Field2
Field3



Hope that helps.

Rick