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