Novice needs help! - Time in and time out problem...
I am using filemaker pro 11 advance and preparing the student entry database. I have two tables, student table for student information and history table to record the time in and time out of the students in the portal shown in the student table. If student scan their ID then FM will find that student record and display the status in the student interface and supposedly record the time in and time out automatically and show it in the timein and time out field in the porta respectivelyl. My problem is how to do this, time in and time out doesnt show in the portal. Is there any script or any relationships on this? Thanks in advance.
student table history table
1. student id student id
2. student number check in
3. firstname check out
4. lastname etc...
relationship via student id = student id