AnsweredAssumed Answered

Value List Question from a portal item

Question asked by logancornelius on Aug 14, 2018
Latest reply on Aug 17, 2018 by logancornelius


I've been working in filemaker for about 2 year now and have done some advanced stuff but for some reason I've avoided conditional value lists and not tried to understand them and maybe that's because of the use case I'm trying to implement. Here is the layout of the tables I'm using in the use case

 

Submissions>----- contacts----- <contacts roles join>------- roles

 

In the submission LO I want the user to be able to select themselves from the value list based on contacts, but I want that contacts list filtered based on if they're related to a certain role in the roles table. This is more than a standard conditional value list I believe, but I've been wracking my brain trying to get this to work and I'm getting way too frustrated haha. any help would be appreciated or if it's not possible that'd be great to learn too cause then I can lay this to rest.

Outcomes