To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68337 Issue #|68337 Summary|asking for parameters should offer a list box for fore |ign keys, where possible Component|Database access Version|680m181 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|none Assigned to|fs Reported by|fs
------- Additional comments from [EMAIL PROTECTED] Thu Aug 10 04:56:24 -0700 2006 ------- Open the attached database, implementing a (very simple) administration of appointments. It contains a query listing all appointments in a given location, where this location is a parameter which the user fills in when executing the query. With the current Base functionality, you can design this in two ways: - Let the user enter the mere number of the location. The disadvantage is that this number is not known usually, since it's an implementation detail of the database. - Let the user enter the name of the location. The disadvantage is that this is prone to typing errors. It would be nice if the parameter dialog were clever enough to recognize that the location ID, which it asks the user for, is a foreign key into the "locations" table. Since this table contains only a primary key - the counterpart of the foreign key - and a name, the dialog should offer a listbox will all names, and automatically translate this into the location ID. --------------------------------------------------------------------- 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]