You could use candidate key to link your table, but candidate key also require that the field doesn't have dupes.

>Oooohhhhh I see. Can I use Cand (or whatever that is called) instead of primary because the two tables can have dupes index field. Will this work with the Database Designer?