Preventing Entries that are Partial Duplicates

  • Thread starter Thread starter tbl
  • Start date Start date
T

tbl

On occaision, I've used multiple keys to prevent duplicating
data in certain combinations of fields.

Today, I have a situation where duplicate keys doesn't seem
a logical choice, so I'm wondering what simple options I may
be able to choose from for preventing duplicate data in a
couple of fields like time and place.

I have that gnawing feeling that I'm overlooking something
very easy.

Any thoughts appreciated.
 
If a unique index on the 2 fields in question won't work, then I'm afraid
you will need to supply more information before anyone will be able to offer
constructive suggestions.
 
If a unique index on the 2 fields in question won't work, then I'm afraid
you will need to supply more information before anyone will be able to offer
constructive suggestions.
Click to expand...


Thanks for the reply Lynn.

By "unique index", do you mean a compound key?

I tried selecting two fields in this table to make a
two-field index, but the properties box (lower left)
dissappeared as soon as I made the selection.

Will Access allow a compound index, in addition to having a
Primary Key that is not involved in this index?
 
tbl said:
By "unique index", do you mean a compound key?

I tried selecting two fields in this table to make a
two-field index, but the properties box (lower left)
dissappeared as soon as I made the selection.

Will Access allow a compound index, in addition to having a
Primary Key that is not involved in this index?
Click to expand...

In table design view go to menu...

View
Indexes

In the index dialog enter

IndexName FieldName
FieldName

(at the bottom)
Unique (yes)
 
In table design view go to menu...

View
Indexes

In the index dialog enter

IndexName FieldName
FieldName

(at the bottom)
Unique (yes)
Click to expand...

Yeee Haawww! (something new for me!)

Thank you, sir!
 
You could tell by all the wide, open space... between my
ears?
Click to expand...

Now, as a Texan myself, i would never say such a thing. That would be
reserved for Okies. ;-)
 
Now, as a Texan myself, i would never say such a thing. That would be
reserved for Okies. ;-)
Click to expand...

HEY!!!


John W. Vinson[MVP] and former resident of Tulsa and Sallisaw
 
Now, as a Texan myself, i would never say such a thing. That would be
HEY!!!
Click to expand...

No worries. I can say that because most of my relatives (my dad and nearly
all his relatives) are from Oklahoma.
 
Back
Top