Question

can we create relationship between two tables using a unique field​

Answer 1

Explanation:

Create between 2 tables if at least one of the two selected columns hosts a distinct,unique list of the key values....add an intermediary table made of the list of distinct key values to the model,which will then be linked to both original columns.