I have an existing business process that relies heavily on the value selected in a drop-down field in a form. The drop down values are actually user account names. There are 4 values in the drop down. My client now wants me to only show 2 of these values if a user selects 'No' in another, previous field.
The options available in my existing drop down are
Mary (value = maryusername)
Joe (value = joeusername)
Ahmed (value = ahmedusername)
Shahera (value = shaherausername)
So, if PreviousField selection = 'No'
Then, in the drop down, only show
Mary (value = maryusername)
Joe (value = joeusername)
Is this possible and, if so, how would I go about it. Any ideas welcome, I don't want to have to change my rather complex business process.