Possible Selection

[#1]

I have two Fields 'Market' and 'Product'.

The table is Like this

Market	Product
A	K
A	L
A	M
A	N
B	P
B	Q
B	R
C	X
C	Y
C	Z

Product K.L,M,N fall under market A,    P,Q,R  fall under market B and X,Y,Z fall under market C.

Now if i select a Product the corresponding market gets filtered but i want the filtered market to be selected. How can i do that.

I have attached a sample QVW for the same.

[#2]

I don't know exactly what you want but if you have for example a field qty then you can use this as expression to sum the quantity on the whole market if you select a product:

sum({1<Market>}qty)

Does this help you a bit?

[Anonymous]

Create a trigger on field Product, on event OnSelect (document priperties, triggers).  The action should be Selct Possible in field Market.

Regards,

Michael