Retreiving Data while not using Display field on a table

[Walter Toney]

Im trying to figure out how to get data from a table using a Lookup Select Box. im using that variabe on the request because the field (Application) is not the display field in the table,. below are some details. if you need more let me know

fields on a request

Application (re_application)

App ID (re_app_id)

Manager(re_manager)

Application is using a  (Lookup Select Box) Looking at the name field on the (app_management Table) this is NOT the display field.

Fields on the Table

Application Name (name)

App ID (u_app_id)

Owner (u_owner)

what i want it to do

When the User select the application they want, I would like to have the system look at the application selection and auto populate the App ID (u_app_id) in the App ID (re_app_id) and Owner (u_owner) into the Manager(re_manager) in the Service Request. I have tried a script and even tried reference qualifiers but nothing is populating so I'm here to ask what you think would be the best way to do what I'm looking to do.

[James Chun]

Hi @Walter Toney,

I would change the Application (re_application) variable to a reference type variable that references the [app_management] table.

Then within the other two variables (App ID and Owner), use the Auto-Populate to get those attributes.

e.g.

In your example, the Dependent question would be the Application (re_application) variable and the Dot walk path would be the App ID and Owner.

Cheers