GUSTAVO Posted November 5, 2020 Report Share Posted November 5, 2020 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 Quote Link to comment Share on other sites More sharing options...
0 sandy159 Posted November 6, 2020 Report Share Posted November 6, 2020 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! Quote Link to comment Share on other sites More sharing options...
0 CoopperBackpack Posted November 6, 2020 Report Share Posted November 6, 2020 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 Quote Link to comment Share on other sites More sharing options...
0 SinJunYoung Posted April 30, 2021 Report Share Posted April 30, 2021 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 Quote Link to comment Share on other sites More sharing options...
Question
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
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.