To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99920 Issue #|99920 Summary|Allow more flexible combo box entry in forms Component|Database access Version|OOo 3.0.1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|FEATURE Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ptoye
------- Additional comments from [email protected] Thu Mar 5 12:58:21 +0000 2009 ------- A new feature in Forms to allow a user to display a field in a combo box, and use the selected record to insert another field into the database. Rationale: When there are two linked tables, the key used for linking is often an auto-incremented number. At the moment, if a user wants to change (or enter) the linking key in a main table, he can add a combo box to the form which allows him to select only the key. If the key has been auto-generated this isn't very useful. The user needs to be able to see the information behind the key to select the relevant record, but it's the key which has to be inserted into the main table. Example: Main table has fields Info, SubKey Linked table has fields Key, SubInfo Relationship Main.SubKey<>Linked.Key The user wants to look at Linked.SubInfo in the combo box, and insert Linked.Key into the selected record in Main. I hope that's clear. A possible implementation would be to have more than one column displayed in the combo box (SELECT Field1, Field2.... from "Linked"), and have an extra property which told Base which of the columns to select for insertion into the main field. This property could be either numeric (column number - which I seem to remember is how Access does it) or - even better but more work for you - the field name (or alias) which could be selected via a combo box on the Properties page. --------------------------------------------------------------------- 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]
