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.