I am not entirely sure what your TODAY 2 is for...
I really don't think you need the ROLL Call Days either.
If you have the TODAY table and change it's name to ROLLCALL (just add the date fields in it) or similar.... you can have direct relationships with the PEOPLE to be able to add their clock in and out events.... in the ROLLCALL table.
A self-join relationship would be where you have say the field DateIn related to DateIn in the same table (show me all those records with the same Date in as this record)... or perhaps G_Date related to DateIn (show me all those records where the date entered in the global field is the same as the DateIn)... or perhaps DateIn + PEOPLE_PK related to DateOut + PEOPLE_PK (show me the records where this same person logged out on the same date as the login record I am looking at)...
There are lots of variations... but essentially a self-join is just matching the data in the same table.
If you have a DateIn and a DateOut field and use the G_Date global scenario to relate to the data in ROLLCALL... you can first create a calculation which combines the DateIn and the DateOut into one field for matching. eg. =DateIn & "¶" & DateOut. Entering Todays date in G_Date would show (in a portal) all log IN and OUT records. You could have another field which calculates all the dates in and out for the last 7 days... it THIS WEEK etc.
TODAY2 is how FIlemaker displays a Self Join.
I am using ROLL CALL almost like dummy table so that I can display some other layouts.
Thanks for your help, I ll make another version with your suggestions and see how it goes.