Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi Eduard
see example
best regards
Chris
May be like attached sample. Front end solution. Using P().