10 Replies Latest reply on Jan 5, 2014 12:20 PM by Maikel

    looking at past results and edit field in order to determine a field

    Maikel

      Title

      looking at past results and edit field in order to determine a field

      Post

           I know I have to make a calculation, but how.....

           My filemaker solution record timestamps, calculated from different fields. The main fields in this table that I need for my calculation are.


      REG_TABEL
           ID
           Employee (unique character (username)

           TimeStart (Timestamp calculated on the TimeStart_time and TimeStart_date)
           TimeStart_time (Time input field)
           TimeStart_date (Date input field)

           TimeStop (Timestamp calculated on the TimeStop_time and TimeStop_date)
           TimeStop_time (Time input field)
           TimeStop_date (Date input field)

           _______

           My solution, calculate a start and stop time and the account name is an important field that the registration ID field next to the distinction from other registries. 

           Now my question;
           I want to know when a employee creating a new record of that employee already made a registration on the same day as the new entry is made and what is the last known TimeStop (Timestamp) is in time not in order of registration. From that record I want to use te TimeStop_time field and import in the field of the new record (TimeStart_time)

           I hope someone can help me with this calculation..

           Maikel