Relationships, 2 in 1 table

[Bengriffiths]

I have already made a relationship 1 to many, i want to add another relationship. I put the name of the feilds i want to join up in the drop down box. I put "enforce in..." and "Casgade update related fields" on and join type 2. Then when i press ok, it comes up with "file title " to "film title" and comes up with "no unique index found with the referenced field of the primarytable".

Does anyone know what this meens?

 

[misscrf]

This is so hard to explain, and to understand! Let's see if I can get it right.

The field, that is being reference in your join, is in a table. That table does not seem to have a unique identifier.

I don't know why that would make a difference, but it seems to be. I would try taking off the enforce referential integrity, and the cascade. It should work without those 2.

misscrf

Management is doing things right, leadership is doing the right things

 

[BNPMike]

Why not put a unique index on the referenced key? Only takes a second or two.

 

[PHV]

A one to many relationship needs a unique index on the one side (the referenced) and a duplicate index on the many side (the referencing).

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244