Unique index

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I would like to create a unique index that will not allow duplicates
from three fields that are each in a different table. Is it possible?

Thanks,

Dave B
 
I'm sure it probably is however why would you want to do this?

Surely it would be better to have all of these records from the three
tables in one table with a field that shows which group they belong to.

This seems to me to be a better way to design.
 
Ok - now I understand a little better. You could do with a unique index
that is letter + autonumber where the letter was C for canister and S
for spot etc. Would this work?

If so i'll find some info for you.
 
No, what I mean is an index to prevent duplication. Two records should
not have the same canister, tray and spot. If these three fields were
in the same table that would be easy, but they each are in different
table.

Thanks

Dave B
 

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

Multi Column Unique Index with nulls 2
Validation rule, index or neither? 6
Avoid Dups 2
How to create an index with more than 10 fields? 11
How do I find the indices on a table in Access 2003? 4
do not duplicate date values in form 1
field value concatenation VBA 1
MS Access Avoiding redundancy 1

Back
Top