5 Replies Latest reply on Feb 28, 2012 2:48 PM by philmodjunk

    Find matching field value and set field



      Find matching field value and set field


      I have a table WORKPLAN in which I have set up a field DAY/MONTH/YEAR it includes records from JAN/2012 to DEC/2012 like this 


      WorkID           Month/YEAR            Status

      1                        26/Jan/2012          1

      2                        26/Feb/2012          1

      3                        26/March/2012       0

      4                        26/April/2012         0

      5                       26/May/2012           0


      and another table named Deliverable which has the below fields. 


      Report                          Deadline Date                     Status

      Monthly Jan Report           25/JAN/2012                         0

      Monthly Feb Report           25/FEB/2012                         0

      Monthly March Report        25/MARCH/2012                    0

      Monthly April Report           25/APRIL/2012                     0



      Now I want to set up a button on the WORKPLAN layout name SUBMIT by which when clicked I want it to find the MONTH/YEAR in the Deliverable table and match the record and set the Status field of Deliverable table to 1.