I'm not sure on the best way to go about this - but I have a 'User Access Orch References' table that has orch_name, input parm 1 and input parm 2 which is the source for fields on another table/form and needs to cover various orchestrations for Access Request so there may or may not be a relationship between input parm 1 and input parm 2 depending on the orchestration input requirements. This table is also populated through LDAP connections that run nightly. It would be easier if this info was in a Choice List.
So when the Orch-Name-Add is selected in the screen shot below via Choice List (if I referenced the 'User Access Orch References' table to get this information it showed multiple times for each record in the table, so went with Choice list, but if there is another way, please advise).
Then the drop down for the Input Parm 1-Add is populated (via javascript reference qual in the Dictionary entry) with values from the 'User Access Orch References' table for selection.
The question is, I need the Input Parm 2-Add to auto-populate from the 'User Access Orch Reference' table based on the Input Parm 1 value ONLY if the Orch Name is (TH) Add User to Grp.
What is the best way to do this?
