AnsweredAssumed Answered

look up value

Question asked by OvidioSiu on Jan 20, 2011
Latest reply on Jan 20, 2011 by philmodjunk

Summary

look up value

Product

FileMaker Pro

Version

Ver. 9 & 11

Operating system version

Mac OS

Description of the issue

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.

Outcomes