I am having a difficult time trying to set a relation of a regular key of one table to a candidate key of another table. I have tried the set relation command and also making the regular key a foreign key to the primary key. Any suggestions?