Helping on lookup issue
I am new to filemaker, could anyone help with the following task.
I am trying to lookup a tax deduction. I create a table which list the range of income and deduction value (e.g. minIncome, MaxIncome, taxDeductionValue). I create another table which has InputIncome and DeductionResult.
I want to have to the end result doing the following: First I want input a value, then the system will automatically lookup the value range and generate a value deduction based on my table.
Basically, a set of coding to do a tax deduction on an income.