Filter records in a parent table based on a "User - List" field in a child record

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I'm managing a database for a sports league. I have a table of "games", and a table of "teams", connected through a many-to-many relationship with a "teams at games" table. Each team has a user list field where the league commissioner adds every team's coach. I'd like to make a report in "games" that only shows records applicable to the relevant coach/user. Its similar to this question ( except that post had a solution that only works when the child table has a field of type "User" and not "List - User".
Photo of Adam Dowell

Adam Dowell

  • 140 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
You can put a formula checkbox field like this on the Teams at Games called [This is Current User's Team]

Includes([Team members], ToUserList(User()))