Hello AppSheet Community! I need to create a...

(Maryn van der Laarse) #1

Hello AppSheet Community!

I need to create a many-to-many relationship for a beehive harvesting app. Basically, every hive can be harvested multiple times (each hive has many harvests), but every harvest has many hives. While constructing an ERD, you will add another table like HarvestHive to deal with the many-to-many relationship (See example ERD below). Any idea how to capture this logic in AppSheet?

(Suvrutt Gurjar) #2

Hi @Maryn_van_der_Laarse, Based on my understanding of your requirement, you may wish to take a look at the sample app “Order Capture” mentioned below.

In that app,the table “Order Details” is kind of bridge table (HarvestHive equivalent)

and Products and Orders are other tables. Each Product can have many Orders and each Order can have many products. Order Details table references both Products and Orders table.

appsheet.com - Order Capture - An app for managing customers, products, and orders. Order Capture - An app for managing customers, products, and orders. appsheet.com

(Suvrutt Gurjar) #3

You may wish to go through the below article as well.

help.appsheet.com - References Between Tables References Between Tables help.appsheet.com

(Maryn van der Laarse) #4

Hi @Suvrutt_Gurjar, thank you so much for the quick response. This solves my problem. Loving AppSheet so far!

(Suvrutt Gurjar) #5

Hi @Maryn_van_der_Laarse, Thank you for the update. Good to know the references were useful to you.