Issue 68337 - asking for parameters should offer a list box for foreign keys, where possible
Summary: asking for parameters should offer a list box for foreign keys, where possible
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 680m181
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-08-10 12:56 UTC by Frank Schönheit
Modified: 2017-05-20 10:44 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
document to reproduce the bug case (18.14 KB, application/vnd.sun.xml.base)
2006-08-10 12:57 UTC, Frank Schönheit
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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".