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. 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
