- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 12, 2023 05:54 AM - edited ‎Jul 12, 2023 05:58 AM
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 🙂
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 12, 2023 11:40 PM
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