Preventing Entries that are Partial Duplicates

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

 

[Lynn Trapp]

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.

 

[tbl]

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.

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?

 

[Rick Brandt]

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?

In table design view go to menu...

View
Indexes

In the index dialog enter

IndexName FieldName
FieldName

(at the bottom)
Unique (yes)

 

[tbl]

In table design view go to menu...

View
Indexes

In the index dialog enter

IndexName FieldName
FieldName

(at the bottom)
Unique (yes)

Yeee Haawww! (something new for me!)

Thank you, sir!

 

[Lynn Trapp]

Yeee Haawww! (something new for me!)

You must be a Texan.

 

[tbl]

You must be a Texan.

You could tell by all the wide, open space... between my
ears?

 

[Lynn Trapp]

You could tell by all the wide, open space... between my

ears?

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

 

[John Vinson]

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

HEY!!!


John W. Vinson[MVP] and former resident of Tulsa and Sallisaw

 

[Lynn Trapp]

Now, as a Texan myself, i would never say such a thing. That would be

HEY!!!

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