2 Replies Latest reply on Jan 20, 2011 12:24 PM by OvidioSiu

    Helping on lookup issue



      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.