Multi field list in drop down list

[wildblue]

Greetings and thank you in advance for you time in reviewing this issue. Not sure of the verbiage to explain it exactly, but hopefully this will work. I am using

Ubuntu 16.04 LTS
Libre Office Version: 5.1.4.2
Build ID: 1:5.1.4-0ubuntu1

Am pretty happy with the database I am designing, but looking to make it better. One function of the db is a correspondence log. In the drop down list to display recipients of correspondence, currently lists only the last name. This works, unless their are two recipients with the same last name.

How can I, is there a way to have the drop down list display both the First and Last names of recipients to ensure, and cause it to be easier for users to select the correct recipient?

Thank you in advance for you assistance in arriving at a solution.

~Respect

wildblue

[ManoEngel]

Hi,
Your current listbox sql looks pobably like this:

SELECT “lastname”, “id_person” FROM “namesource” ORDER BY “lastname” ASC

by changing it to the following:

SELECT “lastname” || ', ’ || “name”, “id_person” FROM “namesource” ORDER BY (“lastname” || ', ’ || “name”) ASC

you should get the requested list.
Obviously, you will need to amend the fields- and table-names.

[wildblue]

Thank you for the reply. Will play with it and see how it works out for me. Am new to SQL, so I have a learning curve there to overcome LOL This will be a good lesson. Again Thank You