Apache OpenOffice (AOO) Bugzilla – Issue 108099
allow list box controls to display columns other that the first column of the bound table/query
Last modified: 2017-05-20 10:47:50 UTC
see attached doc: open form in edit mode, toggle to live mode. There are relations between the id's of table_fk1 and table_fk2 to the main table of the form. Columns 4 and 5 are formatted as listboxes, bound to table_fk1 and table_fk2. The difference is that in the table_fk1 the text value is in column 2, but in table_fk2 is in column 1. So the bound field value in column 4 is set to 2, in column 5 to 1 (the help pages suggest to use value 0 for the first column, which is IMO wrong). What should happen: The values of the text column should be displayed in both columns. What happens: The values of the id is shown in column 4, column 5 is correct. Toggle to edit mode and check the settings of the columns. Columns 6 and 7 are formatted as listboxes, bound to sql select command of table_fk1 and table_fk2. What should happen: columns should show the text values of the corresponding tables table_fk1 and table_fk2. What happens: The id's are shown.
Created attachment 67015 [details] file to reproduce
Hi, As far as I understand the list boxes in forms the first field is alway the field which will be displayed in the list box. f.e. if you use a table as list box content the first field in the table is displayed and the one you specified in the bound field property is used for the relation. If you use a sql string you need to specified 2 field in the sql string ; one for displaying and one for the relation. Bye Marc
changing to ENHANCEMENT, grabbing, confirming, targeting (to Later, for the moment)
Reset assigne to the default "issues@openoffice.apache.org".