Issue 52912

Summary: Make use of foreign keys to guess form object types in table wizard
Product: Base Reporter: johnix <thomas.tempe>
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P5 (lowest) CC: issues
Version: OOo 2.0 Beta   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---

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