prevent multi field dupe

D

deb

trying to prevent dupes.
access 2003
want to prevend dupe if ProjectID, UnitNo, KeyMilestonesSubID, ActualDt are
the same.

I setup index and it works except if UnitNo is blank, it will allow dupes in
the other fields.


any suggestions?
 
J

Jerry Whittle

If you make that combination the primary key, it wouldn't allow dupes.
However you couldn't have the UnitNo blank there either.

Have you considered populating the UnitNo field with something bogus like a
0? That would allow using a unique index to keep out dupes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

complicated subform beforeupdate 1
If field =15 save in two tables 2
triggers duplicate msg if change is made 2
prevend dupes if 3
check for two fields instead of one 4
Multi-field primary key, no dupes - but only if one field is empty? 7
Duplicate Record Mess 6
Relationship with a Primary Key? 4

Top