>>Your tables needs to have a primary key index. It's the index that you drag from one table to another to create a permanent relationship.
>
>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?

Yes.