[libreoffice-users] Re: List and Combo boxes

2012-06-13 Thread Alexander Thurgood
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

Re: [libreoffice-users] Re: List and Combo boxes

2012-06-13 Thread Dan
Andreas Säger wrote: 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

Re: [libreoffice-users] Re: List and Combo boxes

2012-06-13 Thread Dan
Dan wrote: Dan wrote: Andreas Säger wrote: 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

[libreoffice-users] Re: List and Combo boxes

2012-06-13 Thread Alexander Thurgood
Le 12/06/12 21:08, Dan a écrit : Hi Dan, 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 I'm not sure I understand you