I am trying to create some dependent fields with employee lists in our Transfer Order form. The form has a select field with a list of company locations to transfer inventory from. The subsequent select field is a list of all company employees that the user will choose from. Once they choose the location from the previous field, I would like that next field to change so that it displays a filtered list of only employees who are located at the chosen location. I tried creating a Saved Search with a list of employees from one of the locations. I then went in and attempted to create workflow that would trigger on the "Transfer From Location" field input, check the value selected, and then set the field value of the Fulfilling Employee to a saved search list (of employees at that location). It doesn't look possible though.
What are some other options to achieve this?