Issue 52912 - Make use of foreign keys to guess form object types in table wizard
Summary: Make use of foreign keys to guess form object types in table wizard
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0 Beta
Hardware: All All
: P5 (lowest) Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2005-08-04 21:25 UTC by johnix
Modified: 2013-02-07 22:39 UTC (History)
1 user (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description johnix 2005-08-04 21:25:18 UTC
First I create a database with a table Person containing the following  
columns :  
 - id integer  
 - name string  
 - birthday date  
 - status integer references Status(id)  
Then, I create a form containing a tablecontrol. The form creation wizard asks  
me to select the table, then the fields I wish to use. I select all fields from  
table Person.  
The wizard guesses the appropriate column types for each column based on its 
SQL type. It creates a numeric column for field "id", a text column for field 
"name", and a date column for field "birthday". 
However, the wizard just creates a numeric column for field "status". It would 
provide a much better user experience if instead, it asked me which field from 
table "Status" to display (say, "name"), and created a "list box" field with 
type of list content set to "sql" and list content set to "select name, id from 
Comment 1 christoph.lukasiak 2005-09-12 14:15:17 UTC
this issue is reassigned to the user experience team for further evaluating