The details of this enhancement are:

Change the Table Selection page of the combo box and list box wizard to allow
selection of Tables, Queries and SQL from current data source

Additionally allow SQL command selection for the display data source. This
should include the ability to open a query designer window with a table or query
preselected. On this second point, this is different from how this feature is
implemented in the different editors where an SQL command is accepted. In these
the query designer is opened with the select table/query dialog opened. IMO, an
implementation here that did the same is acceptable, the request for the table
or query to be preselected from the function within the wizard is an additional
change.

The motivation for the change request is the number of new users that have asked
on the Forum regarding displaying data from multiple columns in the combo or
list box control. Since for new users, new computer users particularly, the
wizard for this data source selection will be the first interface to these
controls, the current implementation makes it appear that this single field
display is the only option available. It is less of a problem for experienced
users of other computer applications, but even then combined with the different
approach to displaying multiple column data from the major competitors
application even these more experienced users can be mislead into believing that
it is not possible with OO.o controls.

I understand that new controls are in the planning stages that would address
multiple field displays, but this change is valid regardless of the control
displaying only one calculated field, or in the future multiple fields. So any
effort here, before the new controls are development should in no ways be
waisted, IMO.


See attached mockup.png for UI suggestion.