Column settings
In this section, we would like to introduce a trick that is going to solve one of the most frequently asked questions in the AppSheet community. The question is how to establish a many-to-many relationship between two tables. Let’s dive in.
Establishing many-to-many relationships
The sample app name is Chapter 12_06: https://www.appsheet.com/templates/sample?appGuidString=3fb14df3-062c-46bf-997a-18da2d878be4.
If we set one column to the REF type, then it will construct a one-to-many relationship between the two tables. The referenced table in the REF column may have an association with multiple rows. One parent row can have multiple child rows, so it is called a one-to-many relationship. Then, if we wish to establish a relationship between multiple rows on one table with multiple rows on another table, how can we achieve this task? As for real-world examples, we may have an app to manage the order of goods, where the app possibly has a table of products...
