There are no primary or candidate keys in the referenced table that match the referencing column list in the foreign key

Error message:

There are no primary or candidate keys in the referenced table that match the referencing column list in the foreign key

Explanation:

The foreign key must reference:

• Primary key, 

or:

• a field with a unique constraint.

Solution:

If you can edit the PK - do it. If not - alter/create a fit unique constraint.