looking at past results and edit field in order to determine a field
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.
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..