I would like to have a checkbox which I can use to have my database choose from either a retail or wholesale tax rate. Basically, I want the tax rate to default to retail if the box is unchecked, and to change to wholesale if the box is checked. I tried setting up a checkbox field and using a CASE statement in my tax rate field, but it's not working. Here's what I have as a calculated value:
Case ( Weddings::tax_wholesale = "Wholesale" ; "0.005" ; "0.0417" )
However, all this does is use the wholesale tax rate if checked, and use nothing if unchecked. Also, the tax field doesn't update in real time. If I check or uncheck the field, and then move to a different record and back again, it will then have updated. I want to be able to have the checkbox update the field while I'm live in the record.
Thanks for your help!