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.
--
Thanks,
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.

--

Lynn Trapp
Microsoft MVP (Access)
www.ltcomputerdesigns.com


"tbl" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
> --
> Thanks,
> tbl

On Wed, 27 Dec 2006 14:48:26 -0600, "Lynn Trapp"
<(E-Mail Removed)> wrote:

>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?

--
Thanks,
tbl

tbl wrote:
> 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)

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

On Wed, 27 Dec 2006 22:27:20 GMT, "Rick Brandt"
<(E-Mail Removed)> wrote:

>tbl wrote:
>> 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)

Yeee Haawww! (something new for me!)

Thank you, sir!
--
tbl

> Yeee Haawww! (something new for me!)

You must be a Texan. :-)

--

Lynn Trapp
Microsoft MVP (Access)
www.ltcomputerdesigns.com

On Thu, 28 Dec 2006 10:12:26 -0600, "Lynn Trapp"
<(E-Mail Removed)> wrote:

>> Yeee Haawww! (something new for me!)
>
>You must be a Texan. :-)


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

> 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. ;-)

--

Lynn Trapp
Microsoft MVP (Access)
www.ltcomputerdesigns.com

On Thu, 28 Dec 2006 13:26:14 -0600, "Lynn Trapp"
<(E-Mail Removed)> wrote:

>> 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. ;-)

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
>>reserved for Okies. ;-)
>
> HEY!!!

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

--

Lynn Trapp
Microsoft MVP (Access)
www.ltcomputerdesigns.com