We’re planning a competition. I’ll have Attendees and Teams. Teams are made up of Attendees (two or four members per team). I want two columns on the Teams table: (1) a count of the number of checked-in members of that team and (2) a total count of members of the team.
The Attendees table will have a Checked-In field that is a Checkbox. Ideally, this would be the field that is being counted IF they are a member of the team.