One to one relationships

[GUSTAVO]

I have some specific fields and want to keep in separate tables.  How can I create ine to one relationships between the two tables?

Thanks 

[sandy159]

Hello @GUSTAVO,

Please check the following articles about relationships: Database Relationships, Relationship Settings.

A one-to-one relationship is used when each record in the first table has only one related record in the second table.

When creating a relationship between two tables, if both fields used in the relationship are unique and set to the same data type, a one-to-one relationship is automatically set.

Hope this helps!

[CoopperBackpack]

Hello @GUSTAVO,

You may want to review these tutorial videos regarding  relationships as well.

1. Data Normalization: https://www.youtube.com/watch?v=oexOYUUyQik
2. One-to-Many Relationships: https://www.youtube.com/watch?v=IstAk982ntA
3. Many-to-Many Relationships: https://www.youtube.com/watch?v=7D8u6Lb2BKU

[SinJunYoung]

On 11/5/2020 at 9:50 AM, GUSTAVO said:

I have some specific fields and want to keep in separate tables.  How can I create ine to one relationships between the two tables?

Thanks 

This is ideal but is rare. I like how you thought of this one actually. But may I know your workflow? Although there are tutorials, there are also best practices if you don't mind. Here you go:

Table and Database Design Best Practices - Caspio Online Help

Best Practices in Creating Caspio Applications - Caspio Online Help

[RuisiHansamu]

Hello, just wanted to verify that sandy159 is correct. In order to have a one to one relationship is to have the same datatype with the field. It helped me manage and configure the Table relationships on my end here: https://howto.caspio.com/tables-and-views/relationships/creating-and-managing-relationships/#:~:text=To edit a,apply your changes. 

Here is a walkthrough article that I used for reference: https://www.caspio.com/blog/video-walk-create-database-relationships-caspio/