Apache OpenOffice (AOO) Bugzilla – Issue 52912
Make use of foreign keys to guess form object types in table wizard
Last modified: 2013-02-07 22:39:09 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 Status".
this issue is reassigned to the user experience team for further evaluating