How to "group by" a column that contains "link to other record" (allow linking to several records)

[Helenelene]

I habe a base with two tables (simplified below):

• 1 for projects & 1 for the people working the projects
• both tables are connected with "link to other record"
• one person can work on several projects (allow linking to several records)

QUESTION:

in the projects table, how can I do a "grouping" by "person" without have all combinations as a group each but always only a single option. 1 Person, all projects listed below.

--> Eg: Group: person A, below all projects the person is working on

INSTEAD OF (what I always get but don't need): Person A, Person B & Person C, below the project that all of them are working on in this combination (and so on)

If that is not possible, I am open for other ideas how best to organize this.

My assumption was: person is unique, project is unique but the challenge is, that one person can work on different projects and vice versa. Do I need to set up a new table, each primary field is the combination of a person & a project? Hope that makes sense... if not, let me know 🙂 

Thank you in advance 🙂 

[TheTimeSavingCo]

If you're only looking for display, you could try using the List view

If you want to add data to a specific project <> person pairing, then what you mentioned re: primary field is the combination of a person & a project would be the way to go