[libreoffice-users] Re: List and Combo boxes

[Andreas Säger <villeroy@t-online.de>]

Am 12.06.2012 21:08, Dan wrote:
> To populate a list or combo box, I have been using single field tables.
> Seems like it should be possible to use a single table for more than one
> list or combo box. (The SQL statement for selecting a field for a list
> or combo box is: SELECT "field name" FROM "table name".) Has anyone
> tried this before? Any problems doing this?
>
> --Dan

In a combo box you "always" want:
SELECT DISTINCT "Field" FROM "Table" ORDER BY "Field"

In a list box you "always" want:
SELECT "Field or Concatenation", "Primary Key"
FROM "Table"
ORDER BY "Field or Concatenation"
Bound field=1
Data field=The form's foreign key

[Example] Relations reflected by list boxes in forms
> http://user.services.openoffice.org/en/forum/viewtopic.php?f=100&t=40444



--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted