Pop-Up menu values.

[adamkarwowski]

i have one field which has 3 diffrent types of values (member, non-member, on-site) on a pop up menu. i have a second field which has 2 values(full, 1 day).

how would i go about it if i lets say, pick member from the first menu, then full from the second, wanted a subtotal field to display $125.00 if for members that pay for a full conference costs 125.00.

another example is if i chose member from the first field, 1 day from the second, it would display $65.00

non members is 150 for full 75 for 1 day.

on site is 175 for full and 90 for 1 day.

i figure its some kind of calculation but i can't figure out how to define a value for a menu item.

 

[lebisol]

-new calculation field
-value list whose values are from this field

> need more info?
:: don't click HERE ::

 

[Nina2001]

This is the beauty of case statements. One calculation field that looks something like this:

Case( member type = "Member" and length = "full", "$125&quot &
Case( member type = "Member" and length = "1 day", "$65&quot &
Case( member type = "Non-Member" and length = "full", "$150&quot &
Case( member type = "Non-Member" and length = "1 day", "$75&quot

 

[adamkarwowski]

thanks so much guys i really appreciate it.