DBLookupComboBox

Bernybon

Hi,

I want to set a dialog form to ask between many choice in my request.

But Because I need to have just one request and get all my records, the choice of the DBLookupComboBox show many time the choice:

exemple: (in the exemple the Field1 is the choice in DBLookupComboBox)

wrote:

// This is what the query give:

TableID Field1 Field2
1            1        1
2            1        2
3            2        1
4            2        2
5            2        3

After I choose 1 or 2 i will get Field2 in my report like that:

wrote:

1 and 2 if I choosed 1
1, 2 and 3 if I choosed 2

But my problem is that in my DBLookupComboBox I get this:

wrote:

1
1
2
2
2

but me I want

wrote:

1
2

thanks for your help