Implementing 1 to many relationships in AppSh...

references
(Tyson Carmichael (FlyTy)) #1

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

(Philip Garrett) #2

+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

(Tyson Carmichael (FlyTy)) #3

Thanks Philip !

I appreciate it.