I’ve got a table of collaborators. I’ve got a table of projects. And I’ve got a table of documents. Each document is linked to a project and a collaborator.
I need to know how many documents are assigned to each collaborator, broken down by project. So Collaborator 1 has 2 documents for Project A and 1 document for Project B, Collaborator 2 has 1 document for Project A and 3 documents for Project B, etc.
I’m trying to figure out how to do that. Any suggestions?