How can i create 1:1 relationship?

[ciaociao]

How can i create 1:1 relationship between 2 tables?

[sbelini]

Create a view based on a unique field on each table.

[NailDyanC]

Hi,

 

Just want to add to the previous comment above,  A one-to-one relationship is used when each record in the first table has only one related record in the second table. This relationship is rarely used because it is usually more efficient to put all of the information in a single table. When creating a relationship between two tables, if both fields used in the relationship are unique, a one-to-one relationship is automatically set. I also highly recommend using a view in joining two tables, you may refer to this link for reference: https://howto.caspio.com/tables-and-views/what-are-views/

You can also check this link for creating table relationships: https://howto.caspio.com/tables-and-views/relationships/

Hope this helps.