To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=45859
Issue #:|45859
Summary:|make combo boxes multicolumn:store an id but show a
|description to the user
Component:|Database access
Version:|OOo 2.0 Beta
Platform:|All
URL:|
OS/Version:|All
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|ENHANCEMENT
Priority:|P5
Subcomponent:|none
Assigned to:|msc
Reported by:|davidbl
------- Additional comments from [EMAIL PROTECTED] Wed Mar 23 06:59:34 -0800
2005 -------
A most useful feature of form design in ms.acess is that in combo boxes have
multi-column capability: you can store an id of an linked table in the data
field while showing a description field or several fields (on the collapsible
box) from the same linked table, thus making very easy to input external keys
from a foreign table into the table that is the data source for the form.
Example: we can select three fields "idemployee","employee","telephone" from a
foreign table as the source for the values shown in the combo-box,set the first
one as the data to store ("dependent column" in msacess) then we set the format
of the combo to three columns to be shown, and the width of the columns to 0
cms;5 cms;3 cms, so the first field (the foreign key) is hidden (the "0"). When
the user expands the combo box, he will see a list of employees and their
respective phones in two different columns, and when selected, the id of the
employee will be stored (although hidden in the combo) in the table.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
