Newbies dblback Posted October 8, 2002 Newbies Posted October 8, 2002 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??
LiveOak Posted October 8, 2002 Posted October 8, 2002 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
Recommended Posts
This topic is 8084 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now