Allow no dups for EVERY field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to not allow duplicate entries when ALL fields have been
previously entered?
TIA
 
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
 
Back
Top