How would I create a list of values with managers name, but using SUPERVISOR_ID as the data source? For instance I want my prompt to have a drop down list of managers names:
Doe, Jane N
Doe, John M
...
But depending on the name that is selected, the corresponding SUPERVISOR_ID will be passed to...