I have a PRODUCT_TYPE table, whic has CHOCOLATE and STRAWBERRY in it. Each of this 2 products has a selling price table, which includes the FOB, CIF, ENDUSER, BP so and and so forth.
1) When i click the CHOCOLATE table, i want the selling price table of he CHOCOLATE component to come out.
2)When i click the STRAWBERRY table, i want the selling price table of the STRAWBERRY component to come out, at the same time, for the CHOCOLATE selling price table to get minimized.
3) When i click the CHOCOLATE table, i want the selling price table of he CHOCOLATE component to come out, at the same time for the STRAWBERRY selling price table to get minimized.
(The selling price table is a CHART by the way)
Is there any way for me to accomplish this ? Using triggers?
You don't need to use macros or triggers, I would suggest conditional display for the chocolate and strawberry tables. The show condition would be something like:
This is fine if you have a couple of tables, but less so if there are a lot of these tables.
If you could possibly have more than 6 product_type selections active at any time, then you will need to modify the expressions:
=wildmatch(GetFieldSelections('product_type', ',', nnn), 'CHOCOLATE') > 0 where nnn is the maximum number of prodcut_type selections you want to be able.
Jonathan
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
I tried putting in the 2 formulas. But i don't understand what is the function of it ? as in, what do these formulas do, or what are they supposed to do ?
