![]() ![]() ![]() ![]() One important item that I failed to tell you is that I was using Base linked to a mySQL database via JDBC. There were a couple of modifications from your example, but it was close enough for me to figure out what I needed to make things work. It’s actually easier with the combo box because you don’t have to mess with that pesky “bound field” selection found in the list box properties. The good news is that the answer you gave works for a combo box as well as a list box. I was finally able to get the combo box to do what I wanted. I have tried to duplicate the syntax of the mySQL commands listed under “bound field” in the list box properties shown in the example, but with no luck. There is an example in the LO Base tutorial on page 108 that shows multiple fields in a list box list selection. I have turned off the wizard and filled in the properties by hand and obtained a functional combo box, but not one with more than one field in the list contents. The documentation does imply that it is possible if the wizard is not used, but it does not give an example of how this is done. In the Base documentation, it does state that it is impossible to have more than one field listed in the list contents of a combo box if the combo box wizard is used. ![]() In both instances the queries run without error and give the appropriate results, but only the field in the first column of a Base assisted query or the first field listed under a SELECT command in a native mySQL query will populate the list contents. I have tried both Base assisted query design, and native mySQL queries in the “type of list contents” and “list content” options under the “data” tab of the combo box properties without success. The table that my form is based on and the table containing fields that I would like to appear in the list contents of the combo box are linked properly. Despite hours of research, I can only get one field to appear in the list contents. I am attempting to set up a combo box so that data from multiple fields (LastName, FirstName, DOB, id) will appear in the list contents of a combo box. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |