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...
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-01-06 08:24 UTC by eberlein
Modified: 2017-05-20 10:47 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
file to reproduce (13.37 KB, application/vnd.sun.xml.base)
2010-01-06 08:25 UTC, eberlein 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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 
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
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 "issues@openoffice.apache.org".