Reference Field Value?

[onlyu2]

Morning,

I'm trying to reference the value of a pop-up menu in an If or Case statement. When I'm doing it though I'm being told there is no field! If my pop-up window is named "popup" and the value in the pop-up window chosen is "first," how can I write a statement saying "if popup equals first, then 15, otherwise 200."

Thanks!!!

Ben

[Kurt Knippel]

You really have 2 problems here. One is an issue with how value lists work and a second with how boolean logic works.

Basically you need to have 2 fields to make this happen. One field is set to use the value list and allows the user to choose an item from the list. The second field is a calculation which converts the item chosen from the value list into something else.

For example:

PopupChoice is a text field formatted as a Popup List using the value list "Popup".

PopupValue is a calculation (number) defined as follows:

code:

---

case (

PopupChoice = "First", 15,

PopupChoice = "Second", 55,

PopupChoice = "Third", 125,

2000

)