How to make a "2 ways" relation between tables?

  • Configure your choice component so that it writes a comma separated list of UserID’s (RowID) into a column in your Teams table (you do this by enabling multi-select)
  • Add a Split Text column in your Teams table that targets the column containing the UserID’s
  • Now create a multiple relation column in your Teams table that matches the split text column with Users->RowID
  • And in your Users table, create a multiple relation that matches RowID with the split text column in your Teams table.

Each of the relations can then be used as the source of a list/collection component. For example, on your Teams detail screen you can add a collection and set the source as the relation in your Teams table, and that will give you a list of all users in that Team.

1 Like