9 Replies Latest reply on Sep 20, 2016 10:45 PM by philmodjunk

    Set Field thats not blank


      I am trying to set a field with a value from one of 7 fields.  My database has 7 fields that can have data entered.  lets say some one enters date in to three of them i need to set a field with the value of the third field.  But if they enter data into 5 of them i need to set field with value from the fifth field.

      The purpose of this is to carry the last data entered forward to the next record.  Please see example.  and Please treat me as the novice i am. Thanks fmp.tiff