Issue 68337

Summary: asking for parameters should offer a list box for foreign keys, where possible
Product: Base Reporter: Frank Schönheit <frank.schoenheit>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: 680m181   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
document to reproduce the bug case none

Description Frank Schönheit 2006-08-10 12:56:24 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.
Comment 1 Frank Schönheit 2006-08-10 12:57:54 UTC
Created attachment 38411 [details]
document to reproduce the bug case
Comment 2 Marcus 2017-05-20 10:44:46 UTC
Reset the assignee to the default "issues@openoffice.apache.org".