3 Replies Latest reply on Feb 11, 2010 6:35 AM by Melinda

    Perform find



      Perform find




      I have develop grant system. Every grant has their badget & expenses.

      I have 2 tables for this system , Grant and Expenses.



      grant_no, owner_name, amount_approved, date_start, date_end,

      amount1, amount2, amount3, year1, year2, year3


      (Let's say, this grant for period of 3 years. If amount_approved of this grant is $90,000, it can be paid 3 times

      for each year, $30,000 for year1, $30,000 for year2 $30,000 for year3. So I need to record the payment of each year).


      My problem is when I want to find the records for the payment of year 2009 for example,

      the value 2009 maybe in field year1, year2 or year3.

      Normally find the record using just 1 field, so how I wat to find the records in multiple fields.