How to add a table (list of values) in a detail view?

AppSheet AppSheet Q&A
1

Hi all,

I have people belonging to teams.

A people can belong to more than one team.

If I have a detail view of a team I would like to show a list of all people belonging to that team via a select statement.

How can I do that?

Thank you for all your great answers, Joachim

2

Sounds like a many-to-many relationship. So have 3 Tables: Person, Team, and Person_Team.

https://help.appsheet.com/en/articles/961426-references-between-tables

1 Like