Byron,
Did you by chance see my post on Avoiding Redundant Records, and if so,
would this indexing technique apply?

Thanks,
OldBlindPew

"Byron" wrote:

Hello Steve,

Bruce is correct, but didn't describe HOW to do it... Up to 10
fields may be conjoined into a unique index and referential integrity
applies to the group of fields. This is a sometimes complex technique
which should be considered before using it..
This is accomplished by naming the index in table design, Indexes,
where there is an Index Name on the first field, and a blank Index
name beyond on all the rest, then setting the Unique attribute (not
primary, Unique ) to yes. (if theres an "index name" on each field,
its a one field index)
These fields now act as a group field index and can also be used for
referential integrity into other tables (with an identical index
structure).

I've captured screen shots if you'd like them sent directly to your
eMail address.

Hope this helps,
Byron Downey

.