How to add an one-to-one relationship?

There's two ways to enforce the one-to-one relationship: convert the foreign key to a primary key, or to constrain it as unique. We'll be reaching the latter way. 


Relate your source table with the destination table by applying a one-to-many relationship (as taught here). Then, apply an unique constraint (also showed over here). 

This article was helpful for 9 people. Is this article helpful for you?