I have a solution that tracks meetings for projects.
Organizations have projects PROJECTS
Organization have stakeholders STAKEHOLDERS
One project has many stakeholders and each stakeholder can be working on many projects PROJECTS | STAKEHOLDERS
Projects have meetings (lots of them) MEETINGS
A MEETING can have multiple STAKEHOLDERS and I want to choose only STAKEHOLDERS associated with a project from a conditional value list; PROJECT | STAKEHOLDERS. This results in a join table, MEETINGS | PROJECT | STAKEHOLDERS.
I can create a conditional value list to display only MEETINGS associated with the PROJECT (shows all or none of the MEETINGS), nor can I get the layout to display only PROJECT | STAKEHOLDERS (shows all of none of the PROJECT | STAKEHOLDERS).
I know it is relationship based but I cannot for the life of me figure it out.