Quick Tip Friday - Joining Multiple Tables

You can't accomplish table merges directly in AppSheet like you can in a database or query function in sheets. However these are some ways to display data from another table in your app.
Learn more about displaying information from other tables:
support.google...
Learn more about building apps:
Creator Community: community.apps...
AppSheet Blog: blog.appsheet....
Use your data to build powerful mobile apps. Get started for free with AppSheet: www.appsheet.com/

[@ViktorLesyk]

Can you show how to properly create a many-to-many relationship via the junction table in AppSheet?

[@FiggyCricket]

Well a many-to-many relationship is first defined in the data structure. So if an Order can have many Items, and an Item can be involved in many times of Orders, that is usually defined as a third table or junction table like Order_Items. In AppSheet, you would just add all three tables to your app and set up the correct ID columns to a "ref" data type in the junction table Order_Items and point them to their correct tables. AppSheet handles displaying those related records automatically using related lists and you can add them as a "column" to any of your views in AppSheet.

[@ChristianUtama]

@FiggyCricket I want to build app with many to many relationships.
So this junction table should look like this?
Unique id, order id, item id
My current app is in glide now, it's for running event, si every Saturday we make a running event that can be attended by many runners, and runners can attend many events.

[@jonathanschneider580]

How do I get the second table that "looks up" to update its values when the first table is edited?