Issue 108099 - allow list box controls to display columns other that the first column of the bound table/query
Summary: allow list box controls to display columns other that the first column of the...
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOO320m7
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-01-06 08:24 UTC by eberlein
Modified: 2017-05-20 10:47 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

file to reproduce (13.37 KB, application/vnd.sun.xml.base)
2010-01-06 08:25 UTC, eberlein
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description eberlein 2010-01-06 08:24:37 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.
Comment 1 eberlein 2010-01-06 08:25:32 UTC
Created attachment 67015 [details]
file to reproduce
Comment 2 marc.neumann 2010-01-07 08:25:52 UTC

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
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
Comment 3 Frank Schönheit 2010-01-11 12:02:24 UTC
changing to ENHANCEMENT, grabbing, confirming, targeting (to Later, for the moment)
Comment 4 Marcus 2017-05-20 10:47:50 UTC
Reset assigne to the default "".