I have a two dropdowns, 'business unit' and 'coordinator'. I need the coordinator dropdown to be selected based on business unit when the business unit changes (due to the user selecting an option).
For example:
Business Unit A - Jennifer Paschal
Business Unit B - John Smith
Business Unit C - Jane Smith
I need this to act as a 'default' value so that if I select Business Unit A, it will populate Jennifer Paschal in the coordinator dropdown but I can still manually select Jane Smith.
In other words, one dropdown's value needs to change when another dropdown's value is selected but still be a working dropdown.
I am not sure how to implement this functionality. Ideally both fields would be drop down fields. The ability to change the coordinator manually is really important to the end user here. Do you have any suggestions, examples, methods on how to accomplish this?
For example:
Business Unit A - Jennifer Paschal
Business Unit B - John Smith
Business Unit C - Jane Smith
I need this to act as a 'default' value so that if I select Business Unit A, it will populate Jennifer Paschal in the coordinator dropdown but I can still manually select Jane Smith.
In other words, one dropdown's value needs to change when another dropdown's value is selected but still be a working dropdown.
I am not sure how to implement this functionality. Ideally both fields would be drop down fields. The ability to change the coordinator manually is really important to the end user here. Do you have any suggestions, examples, methods on how to accomplish this?
------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------
