AnsweredAssumed Answered

Filtering a Drop-Down List or value-List

Question asked by James_L on Jan 19, 2019
Latest reply on Jan 20, 2019 by planteg

I have a "Contacts" Table and a "Groups" table. 


Each contact is joined to one or more records in the Groups table via a Contacts_Groups_Join table.


In a portal, I have a drop-down field that lets me select a job from a value list, and then another so I can choose any contact in my Contact table for the chosen job.   Currently, the choice of Contacts for the job is a value-list drawing from all names in the Contacts table.


What I would like to do is create a script or list or filter that limits my choices of contacts for a given job.  For instance, I only want Contacts in the group "Engineers" to be eligible for the job, "Program JSOC."  Ideally, once I choose the Job, I'd like a script to filter the names shown in my dropdown Contacts field.


Thanks in advance!