Could you help me out with a problem, i'm kinda new to this program, I know the basics though..

Here's my problem

I have one field called GROUP: this field has radio buttons ( 4 different ones, "3hours", "6hours", "12 hours", Other) I have another field called AMOUNT DUE

I want a value entered in the AMOUNT DUE field depending on what radio button I select in the Group Field...

Ex: If I select the "3hr" button in the GROUP field, then I want $50.00 to automatically be entered into the AMOUNT DUE field.

Is this possible??

You can make Amount Due a calculation field with its value based upon the Group field.

Amount Due (calculation, number) =

Case(

Group = "3hours", 50,

Group = "6hours", 100,

Group = "12hours", 200,

"")

The exact calculation will depend upon the exact values entered in the Amount Due field. If Amount Due is a number field, not a text field, the calculation should look like:

Case(

Group = 3, 50,

Group = 6, 100,

Group = 12, 200,

"")

A really exact answer depends upon a really exact specification of, for instance, what needs to happen when "other" is selected, but this is the method.

-bd