Just learning

[SandraLeigh]

I have 3 Tables: TICKETS, CUSTOMER MASTER, TAX CODE

I am entering in the Tickets table: Customer Number, Gross Amount

I'd like to set up a CALCULATE NET AMOUNT button
that will:

1. Retrieve the Tax Code from the Customer Master Record
2. Retrieve the Tax Rate found in the Tax Code file
3. Calculate the Tax and subtract it from the Gross
4. Add populate the Ticket table with the calculated Tax Amount and Net

Could you at least point me in the right direction?

 

[79ssecca]

I have 3 Tables: TICKETS, CUSTOMER MASTER, TAX CODE

I am entering in the Tickets table: Customer Number, Gross Amount

I'd like to set up a CALCULATE NET AMOUNT button
that will:

1. Retrieve the Tax Code from the Customer Master Record
2. Retrieve the Tax Rate found in the Tax Code file
3. Calculate the Tax and subtract it from the Gross
4. Add populate the Ticket table with the calculated Tax Amount and Net

Could you at least point me in the right direction?

First some questions. Do you understand recordset and how to calland use them?
Second, I am not a big fan of storing calculated values back into the table. These kind of transactions based processes can really mess up an other wise great application. What I would suggest is recalculating the results on the screen or report when ever you need the answer. That way it is always correct. Thsi does not mean extra coding either just create a function or class that you call when ever you want the answer. Code it once use it many.

Also, what version are you using?