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 the query.
I am currently using the SUPERVISOR_ID field from the JOB table; however, due to the fact that people don't remember their EmplID, I need to display their names instead of EmplID. I am linking NAMES to JOB to get the supervisor's name. Any help would be greatly appreciated. I am new to PeopleSoft so if I was not clear in my explanation, please let me know so I can try to clarify my question.
Doe, Jane N
Doe, John M
...
But depending on the name that is selected, the corresponding SUPERVISOR_ID will be passed to the query.
I am currently using the SUPERVISOR_ID field from the JOB table; however, due to the fact that people don't remember their EmplID, I need to display their names instead of EmplID. I am linking NAMES to JOB to get the supervisor's name. Any help would be greatly appreciated. I am new to PeopleSoft so if I was not clear in my explanation, please let me know so I can try to clarify my question.