I need to lookup tax rate but not sure how to go about it.
DB1 Info.Name, State, Wage
DB2 Rate.State, RatePercent
On report: Name State Wage Tax
Tax = db1 info.wage * db2 Rate.ratepercent
there are multiple states in db2 and not sure how to lookup the rate and use it for multiplication.
if i just put it in, it will print out multiple lines for every state in db2.
DB1 Info.Name, State, Wage
DB2 Rate.State, RatePercent
On report: Name State Wage Tax
Tax = db1 info.wage * db2 Rate.ratepercent
there are multiple states in db2 and not sure how to lookup the rate and use it for multiplication.
if i just put it in, it will print out multiple lines for every state in db2.