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.
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 Name||Project Title(s)|
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.