My "Teams" table contains multiple "Team Member" records for each Account. Accounts cross many Teams and have multiple Members & Managers. I can easily report on all Accounts showing all Members across all Teams (70,000 records). But I would like to be able to give each Manager a report that shows all Accounts that they have a Member on, but also include the members from the other Teams/Managers. Filtering by Manager obviously does not work, as it removes the team members that don't report to them.
My Team's Table is a child of the "Accounts" Table & the "Sales Staff" Table.
I feel like there is an obvious way to set this up, but I can't come up with it. Any help would be appreciated.