HOW TO DO MANY TO MANY RELATIONSHIP MODELLING...

AppSheet AppSheet Q&A
1

HOW TO DO MANY TO MANY RELATIONSHIP MODELLING IN APPSHEET?

2

@Naveen_N Hi Naveen, to model many-to-many relationship, a bridge table, or associative table, is usually needed. Here’s an article that explains this in more details:

dzone.com - How to Handle a Many-to-Many Relationship in Database Design - DZone Database How to Handle a Many-to-Many Relationship in Database Design - DZone Database dzone.com

3

Thanks For Your Answer. HOW TO IMPLEMENT IT IN APPSHEET.

4

@Naveen_N Suppose you have 2 existing tables A and B, and the relationship between A and B is many-to-many. You will need to create a new table in your app, and this table will be the bridge table. The relationship between A and the bridge table is one-to-many. This means that you must create a ref column in the bridge table that references table A. Similarly, the relationship between B and the bridge table is one-to-many, and you will also need to create a ref column the the bridge table that references table B.

5

Is there any Way to get Set of Rows Automatically in That Table Using list Formula?

Do I need to Add Every row manually?

6

Just dropping in a link to a summary post I made, which contains a sample app, about how to accomplish this.

[Many-to-Many Relationships](https://community.appsheet.com/t/many-to-many-relationships/37050) Tips & Tricks ?

AppSheet be default supports One-to-many relationships: you have one record (say an Order) that has many related records (order details). But there is another relationship connection type that allows you to connect many records to many records you have a table of records (say Products) where each record can be related to many records in another table (say orders). this means when you look at a product, you can see a bunch of related orders - and when you look at an order, you will see a bu…