Can someone show me how to connect a one to many relationship in my app?
I have 3 tables
Owner Table
Properties Table
Owner- Properties Table
1 owner can own many properties and 1 property can have many owners
all the tables have a unique id and the Owner-Properties Table has both the other 2 UIDs to create the relationship.
I imported all 3 tables but do not know where to connect them
Help!
Hi @ikohnx! Welcome to the community!
This may help:
Hi @ikohnx,
As rightly mentioned by @Kirk_Masden, you may wish to go through the concept of referencing as described in the referred article.
It sounds that you have created Owner-Properties table , which is a kind of bridge table between Owners table and Properties table. You have mentioned that one owner can have many properties and one property can have many owners.
If so, I believe you may refer the sample app โOrder Captureโ that has a similar bridge table concept implemented.
In the sample app, โOrder Detailsโ table is kind of a bridge table between Products table and Orders Table. One order can have multiple products and one product can have multiple orders through this Order details table.
I hope this helps.
User | Count |
---|---|
40 | |
29 | |
22 | |
20 | |
15 |