I need to update a calculated field to store the sales tax of a taxable item. I have a checkbox field (taxable). If it is checked the unittax field should be .06quantityunitprice. Otherwise the unittax field should be zero.
I have tried this and many other variations without success. In the Before record update of the edit page:
dim istax as string
istax= e["taxable"].tostring()
if istax <> db.null then
e["unittax"]=.06*e["unitprice"]*e["quantity"]
else
e["unittax"]=0
end if
Can anyone indicate the correct syntax.
Thanks in advance.
