Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create a list of value

Status
Not open for further replies.

whitneya

Technical User
Sep 17, 2007
1
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top