Hi! I have 2 tables - one with a long list of individual clients, and another listing “teams”, which the clients belong to.
The client table has 2 fields: “Team” & “meal preference”.
I want to summarise the meal preference data in the Team table tab...