Le 17/12/2014 09:45, Alex Thurgood a écrit : > Le 16/12/2014 21:43, Joel Madero a écrit : > > Hi Joel > >> I have a form based on a table with FirstName and LastName, I want the >> form to have a dropdown with SELECT CONCAT(FirstName,",",LastName) >> >> Is there a way to do this? >> > > Create a listbox form control. Enter the properties of the control > (right mouse button click on empty part of form, context menu > > Control). In the Data tab, bind your control to the SQL query by > choosing SQL or SQL native from the List content type, then enter your > SQL statement in the field below, or alternatively, click on the > ellipsis and navigate to a query you have already saved. >
Addenda : Or, as I found out with a listbox, instead of a combobox, clicking on the ellipsis takes you to the SQL query designer in SQL mode (even better IMHO). Alex -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
