to refer to the value of a field in the last related record, use the Last function. you can look up this function in FileMaker Help.
Thank you sir!!
Ok so I can get this to work in some cases and some I can't. Maybe there is a better way or writing the syntax.
For example.. I have a CLOCK OUT button that I want hidden if
1. The user has not CLOCKED IN yet today. (No record with today's date)
2. The user has already CLOCKED OUT (Record with today's date has a time in the LogTImeOut field)
In the Inspector Data in the Hide Object When:
Last(staff_TIMELOG::LogDate) ≠ Get(CurrentDate) or (not IsEmpty (Last(staff_TIMELOG::LogTimeOut)) and Last(staff_TIMELOG::LogDate) = Get(CurrentDate))
The calculation is accepted and it seems logical but doesn't work. What might I be doing wrong?