Relationships, 2 in one?

[Theshowstealer]

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?

 

[trucktime]

Unique Index

In the primary table set the property of the field you want the relationship on to
Index 'Yes', No Duplicates. You need to have a unique value in every record for the relationship to work. You can also ad an Autonumber ID field to the table.
Good Luck.

Trucktime