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?
That worked and honestly, I've never done it before and I'm shocked it worked the first go around. The examples in the link helped!
One more question - the Orch_Name -Add field is using a Choice List instead of the value from the 'User Access Orch Reference Table' because the field shows multiple times for each record in the table and I don't care for that for maintenance reasons since we will be adding another block for -Remove and more orchestrations inputs to the 'User Access Orch Reference Table.'
There are a ton of options for fields and not sure if there is one that I can use that would only show unique values in a reference to Orch Name. So for now, only one would show and then when we add another orchestration with various inputs, then it would show 2 Orch Names.
