Hi,
I am using the DBMAN program to store records for a business. In my orders database, I have a a couple of fields that I would like the system to calculate for me and then write to the database file. For example:
I have a field named SUBTOTAL and SALESTAX and LINETOTAL. I would like to be able to enter information into the SUBTOTAL and SALESTAX field, and then have the LINETOTAL calculate the function SUBTOTAL + (SUBTOTAL*SALESTAX). However, I want the script to do this on-the-fly, so that when I click in the LINETOTAL field, the answer to the calculation appears, and then when I click on the add record button all of the fields are stored in the database. Please help me out with the code for this. Thanks in advance.
------------------
-- I call it a "Display of Affection," But the police call it "Indecent Exposure." Go Figure.
I am using the DBMAN program to store records for a business. In my orders database, I have a a couple of fields that I would like the system to calculate for me and then write to the database file. For example:
I have a field named SUBTOTAL and SALESTAX and LINETOTAL. I would like to be able to enter information into the SUBTOTAL and SALESTAX field, and then have the LINETOTAL calculate the function SUBTOTAL + (SUBTOTAL*SALESTAX). However, I want the script to do this on-the-fly, so that when I click in the LINETOTAL field, the answer to the calculation appears, and then when I click on the add record button all of the fields are stored in the database. Please help me out with the code for this. Thanks in advance.
------------------
-- I call it a "Display of Affection," But the police call it "Indecent Exposure." Go Figure.