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!