AnsweredAssumed Answered

Conditional Value List

Question asked by jkwarrington on Feb 24, 2017
Latest reply on Feb 24, 2017 by Jaymo

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.

 

Problem

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.

 

Outcomes