How to select "that contents..."

[ecabanas]

Hi I have a sales table with several orders inside, an another with the products family. I would like to make a salection with the condition "contents"

order     id    Family

a          1     A

a          2     B

a          3     C

b          1     A

b           2    C

c           1     A

c            2   D

If i select "C" in list the result must be:

order     id    Family

a          1     A

a          2     B

a          3     C

b          1     A

b           2    C

Many thank's

Eduard

[#2]

Hi Eduard

you have to set another table with order and family

so when you select Family C from Table_Family1 you get thru order (as key) to Table_Family2 and it will display all families related to order

best regards

Chris

[ecabanas]

Hi Chris,

I did not understand, Maybe I did not explain correctly, I have the main table and a listbox with A,B,C,D

When I select "C" I wanna see the order composition that contents Family "c"

Many many thanks

Eduard

[#4]

Hi Eduard

see example

best regards

Chris

[tresesco]

May be like attached sample. Front end solution. Using P().