Apache OpenOffice (AOO) Bugzilla – Issue 68337
asking for parameters should offer a list box for foreign keys, where possible
Last modified: 2017-05-20 10:44:46 UTC
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.
Created attachment 38411 [details] document to reproduce the bug case
Reset the assignee to the default "issues@openoffice.apache.org".