AnsweredAssumed Answered

Summarizing Related Records in a Many-to-Many Relationship

Question asked by apricity on Aug 22, 2016
Latest reply on Aug 22, 2016 by philmodjunk

I have an existing database that tracks people working on different projects. Although the actual database is more complicated, I have made a graphic that only shows the relationship and basic information related to the area of the database I have a question about. Essentially, each person can work on multiple projects and each project can have multiple people work on them.

 

Screen Shot 2016-08-22 at 12.00.20 PM.png

 

The database is working great but I have been asked to show on each person's profile which other people they have worked with. Essentially I want to show Employee that are related to other Employees based on their work on the same project. Ideally on each Employee's profile, I want a table like this:

 

Other Employees worked with:

Employee NameProject Title(s)
John Doe

Project A

Project C

Jane Doe

Project B

Project C

Project D

 

I started learning FileMaker about 8 months ago so while I am not a complete novice, I am still very new. If someone could help me get started down the right track on this problem it would be greatly appreciated. Do I need to change my database structure to achieve this functionality? Would a portal be involved?

 

Thank you so much.

Outcomes