Implementing 1 to many relationships in AppSh...

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

0 2 343
2 REPLIES 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

Thanks Philip !

I appreciate it.

Top Labels in this Space