Implementing 1 to many relationships in AppSheet
Hey team, I have a games table and some fields have a 1 to many relationships
For example: 1 game can have many rules 1 rule can have many violations
1 violation can have many penalties
How do I
implement this in-app sheet so when the user reaches the point of entering a rule, they can enter multiple rules as a part of that one record?
Thanks
Tyson
+Tyson Carmichael
The following article provides an overview
help.appsheet.com - The โItem-Detailโ Data Pattern
This article describes the mechanics https://help.appsheet.com/data/references/references-between-tables
The essence is to add a Ref in the โManyโ record that refers to the โOneโ record. If the โManyโ records are dependent on the โOneโ record set the โIsAPartOfโ property in the Ref field in the โManyโ record. The Ref field value in each instance of a โManyโ record is always the key of the parent โOneโ record. The โItem-Detailโ Data Pattern help.appsheet.com
Thanks Philip !
I appreciate it.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |