I'm building a solution for a hotel's kids club.
The first time people come we create a record for the parent/ guardian and the kid.
Now, kids are free to come and go as they please, the club just needs to keep record of when they "checked in" and "checked out".
Additionally, I'd like to keep track of how much time did a kid spend at the kids club.
I have 3 tables (Parent, Child, Attendance).
First check in -> Fill out form, create record
From a list with the children we can add them to the kids club attendance, so they check in, and time starts.
When they take off, click the button, check them out and calculate the time they spend playing.
The problem is, there will be multiple attendances and I need to keep track of all the DT (checkout - checkin), in order to summarise and get the info I need.
How to I do that? How do I summarise all the DTs a kid might have?