I don't understand your question.
I want to know when a employee creating a new record of that employee already made a registration on the same day
What is a registration? Is that a new record in the above table?
and what is the last known TimeStop (Timestamp)
Would that be the last known TimeStop by this employee? All records in the table? By this employee on the same date?
From that record I want to use te TimeStop_time field and import in the field of the new record (TimeStart_time)
Which record is "that record"? The current newly added record?
And what exactly will you be importing and into what field? I think you mean that you want to copy a TimeStop_Time of a previous record by the same employee into the TimeStart_Time field of the new record created by that employee, but would like to be sure of that.
The example makes my problem probably understandable.
FileMaker should first check whether there exists record whit a date equal to the date of the new record in this example, 01-01-2014.
As you can see in the image are the records of whit > ID 2,3,4,5 made on 01-01-2014.
Now he has to check whether the name user1 already occurs in one of the records.> So 5 falls off
Now he has to check between records which record the latest actual timestamp has > in this case, the record 4
Now I want the input field stoptime from record 4 duplicate into StartTIME the just created record 6
You can set up the following self join relationship:
Open Manage | Database | Relationships
Find the table occurrence box for this table. Use the duplicate button (two green plus signs) to make a new occurrence of this table. (You aren't duplicating the actual table, just creating a new reference to the same table that you already have.)
Set up this relationship:
YourTable::Employee = YourTable 2::Employee AND
YourTable::StartDate = YourTable 2::StartDate
Double click the relationship line and click the Sort button on the YourTable 2 side of this relationship. Specify that the records be sorted by TimeStop in descending order.
Now click over to Fields, find and double click TimeStart to open Field Options for that field. On the Auto-Enter tab, select the Looked up value option and set this field to copy the contents of TimeStop from YourTable 2.
Thanks for the solution, unfortunately he does not work yet. Can you see where I make a setting error?
I assume that I still have to use the input fields of the original table is that right
"Copy next lower value" does not look like a correct option to use here, but that does not explain why they do not work. You are matching Stop date to Start date and I suggested matching start date to start date. I can't tell if that's incorrect or not as it depends on the results that you want to see when a given record starts on one day and ends on another.
"Does not work" is a bit vague. Does that mean that you are getting no data appearing in the field or are you getting the wrong data?
I get no data at all
What version of FileMaker are you using? I want to test my suggestion in the same version that you are using. That way, I can share the resulting demo file with you if necessary.
That will be very nice!
I found the setting error. Thanks for the file and the information