list box displaying multiple columns

Seb <[email protected]> Sun, 31 Jan 2010 21:04:18 -0600
Newsgroups gmane.comp.openoffice.dba.user
Organization Church of Emacs
Message-ID <[email protected]>
Hi,

I cannot find how to have a list box showing multiple columns from a
table.  This is for a field in a form that is a foreign key (many side)
of the table containing the columns to display.  I thought I could do
this by doing "control properties -> data -> type of list contents
[Sql]", and then under "list content" have a SQL statement such as:

SELECT "col1", "col1", "col2", "col3"

with "bound field" set to the default '1'.  How should this be done?
Thanks.

Cheers,

-- 
Seb