Retrieving the exact fields getting it into the txtbox

A

ARL

Thanks for your time.

My problem goes like this;

Ex. txtgrossfortax = 6000

check employee master table for employee BIR status. If BIR Status = ME2
6000 should get the value of Field5 which is 5600 & % of .30

compute txtgrossfortax - Field5 (value is 400)

6000 - 4917 =

400* 30% = 120 (20% is constant based on tblWTAX Field)

120 + 104.17 = 570.77 (104.17 is constant based on tblWTAX Field)

224.17 should be the tax that will go to the txtWTAX


Table tblWTAX is like this:

BirStatus Field1 Field2 Field3 Field4 Field5 Field6 Field7
% .5 .10 .20 .25 .30 .40 .50
constant 50.00 70.00 90.00 110.00 104.17 150.50 175.98
S 100 1500 2700 3400 5600 7833 9000
ME2 100 2300 3500 4000 5600 7823 15000

Table employee master like this:
EmpIDno (Index)
BIRStatus (Relation with tblWTAX)

PLease help me encode this....

Thank you very much.

Lance Arnold
 
Top