Can someone show me how to connect a one to many relationship in my app?

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:

4 Likes

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.

https://www.appsheet.com/samples/An-app-for-managing-customers-products-and-orders?appGuidString=245700e5-9061-4045-843f-7850b5eb439a

I hope this helps.

2 Likes