Unique Index

[Guest]

I am trying to set up a relationship for three tables. I want the
information from two of the tables to be stored in the third. When I set up
the relationship for the fields I want stored it gives me an error message
that says "No unique index found for the referenced field of the primary
table." I have a primary key set up in all three tables. I have also tried
making all the fields unique. If anyone has any ideas i would appreciate the
help.

Thanks,

Donbenz

 

[Guest]

Hi Donbenz

Best idea would be to not do what you are trying to do.

Set the primary key for each table and use this to link (child) to the 3rd
(parent) table.

To have the same data stored in 2 table is simply not the idea of a
relational database. If you can (it's not "always" possible but most of the
time it is) to store only data that is unique ineach record.

As an example -
Name = John (Is unique even though there are many Johns as it refers
specifically to "this" john)
Shoe color = Red (this is NOT unique as many people will have the same color
shoes)

It's a bit more complex than that but hope you get the idea.

Press F1 and serch on "Create a relationship between tables"