Form and Approval Builder - Lookups with Prompt
Using 8.58.10, 9.2 FS and HR
In many cases PeopleSoft stores a unique ID for a lookup value along with a text description. For example the LOCATION_TBL in HR has an ID for each location (behind the scenes) and then text that the user sees in a drop down as a prompt table).
In Form and Approval Builder is there any way to get that functionality? When I reference the key column of LOCATION_TBL for example, it shows that internal ID on the screen, not the text (long description) that the user would see from the prompt.