3 Replies Latest reply on May 15, 2017 8:48 AM by FileKraft

    Field Data from Last Record


      To explain my dilemma, I have a table called Fuel Usage....there are an number of fields, this issue deals with 3 fields..

      1) Unit Number

      2) Todays End Mileage Reading

      3) Last Ending Mileage Reading


      I want the Todays Mileage Reading value in the record to replace the Last Ending Mileage Reading next time a record is created for that Unit Number to record the  Todays End Mileage Reading.