why is this not possible ?

[chris93]

i want to establish a relationship

btw Table2 and Table1 with ID from Table2 being the primary key

and Field1 from Table1 being the foreign key.

When I check referential Integrity it says

No unique index found for the referenced field of the primary table.



how can I make Table2 my primary table ?

[RuralGuy]

Why do you already have a relationship established using Field1 from each table? Delete that relationship and then try it.