[Solved] Combo display different than value

[xcheshirecat]

Hi, I want my combo or list box to return the id of the user, but display the full name of the user. how do i do that?

[UnklDonald418]

A Combo Box stores the selected item so what you want is a List Box.
The query used for the data source for the ListBox needs to have the user name in the first column. If you have separate fields for first name/last name then you can use concatenation something like “LastName” || ', ' || “FirstName” AS “Name”
the second column of the query needs to be the user ID field.
List boxes display what is in the first column of the query and store the value in the second column.
It is usually best to define the query directly in the Properties List Box dialog.
On the Data tab change the line Type of list contents to Sql
The List contents line is where the query is entered. You can use the query design GUI by clicking on the ellipsis (…) to the right of the line.

[xcheshirecat]

Thanks that thing about the order of the columns wasn't obvious