Let me describe my issue with a mock-up.
I have a database with two tables: People and Projects. People are linked to Projects (people can be on multiple projects and vice-versa). I want to have an information how many People in common each pair of projects has.
I would start with creating a junction table Projects x Projects, lest call it Project Matrix, using a script. And after that is there any way to compare those two?
Here is a database created to present the issue - https://airtable.com/shrQjmLrg3CHtXUlI
Creating some flag for each Project or Person won't work, because in the real thing (the non-mockup) there are hundredths of People and hundredths of Projects.
Can this be done without a script? If this has to be done with a script - how such script would have to look like?