hey all, and thanks for any help:

here is the issue:

i am trying to create an invoice where the description of the purchase appears (field B- currently a calculation field with choose as the function) on the basis of what value is chosen in another field (field A). that field (A) is a value list with four values. all are about 4 words of text. i have tried with field A formatted as both radio buttons and a drop down list, and it didn't work with radio buttons and it (: will only choose the first option in the choose calculation when the other field is formatted as a drop down.

any ideas?

thanks!

Perhaps you can post your calc, and give an example of the data with what you'd want the calc to return.

here is the calculation, as it is currently formulated.

it keeps resulting in "1 ticket & Business Card size ad"

Choose(Yes Ad size 10th="Freshman ($100-250)", "1 ticket & Business Card size ad",

Yes Ad size 10th = "Sophomores ($250-$500)","2 tickets & 1/4 page ad", Yes Ad size 10th = "Juniors ($500-$1,000)", "5 tickets & 1/4 page ad", Yes Ad size 10th = "Seniors ($1,000-$2,500)", "10 tickets & 1/2 page ad", Yes Ad size 10th = "Graduates ($2,500 and up)", "10 tickets & full page ad","")

Looks like you should be using a Case() statement instead of Choose().

that's it. that was so easy, thanks Ender!

Would it still work if the field A is formatted as a radio button?

thanks a lot.

jesse

Sure. A field definition doen't care whether value lists are applied or not.