Template
Sample: Many to Many Relati...
Create orders that have many items. Track items that have many orders.
This app shows how you can create a many to many relationship in AppSheet. In this app, orders have many items and items have many orders. This is accomplished through an intermediate table.
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
To create the many to many relationship, the App uses an intermediate table, Order Items. Each row of the Order Items table references one Order and one Menu Item. An Order has many Order Items. A Menu Item has many Order Items. This creates the bridge that allows an Order to (indirectly) have many Menu Items.
I also added a few visibility formulas to improve the views, and created an action which uses a LINKTOFORM formula to allow users to add menu items to their order.
This is a preview of the data sets used in the app.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...