R
Ray_Johnson
I have a protected form. One of the fields is a dropdown box with three
options (A, B, and C). I want to have another field show "Apples,"
"Bananas," or "Cherries" based on the A B or C selected in the first field.
I figure it has something to do with an IF field, but I can't understand how
to nest.
In other words,
IF Field1 = "A" "Apples" IF Field1 = "B" "Bananas" IF Field1 = "C"
"Cherries" ""
(Since it is a dropdown field, there would need a null string, right?)
options (A, B, and C). I want to have another field show "Apples,"
"Bananas," or "Cherries" based on the A B or C selected in the first field.
I figure it has something to do with an IF field, but I can't understand how
to nest.
In other words,
IF Field1 = "A" "Apples" IF Field1 = "B" "Bananas" IF Field1 = "C"
"Cherries" ""
(Since it is a dropdown field, there would need a null string, right?)