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: [email protected] 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
