[libreoffice-users] Re: List and Combo boxes

[Alexander Thurgood <alex.thurgood@gmail.com>]

Le 12/06/12 21:37, Andreas Säger a écrit :

Hi Andreas,


> 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

I seem to recall having seen somewhere on the OOo dev lists that it
should now be possible to directly select Bound field=0, and still have
your sorted distinct data on the other data field, or have I muddled
things up ? This was part of the development that went into OOo3.4, but
perhaps it didn't make it into LO ?


Alex


-- 
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