2 fields in ListBox Base form

[K0r5hun]

Table “users” - id, first_name, second_name
Table “questions” - user_id (id from the first table), question, answer.

Help me… How create a drop-down list in the form with 2 fields from table users in it - “Name and Surname”?

Values of dropdown list must be:

"Name1 Surname1"
"Name2 Surname2"

LibreOffice Base

[K0r5hun]

ADD SQL string in ListBox:

SELECT DISTINCT "first_name" || ' ' || "second_name" "user" FROM "users"