Please help: automatic time in and time out using ID with barcode
I am currently working on a database for the gate entry system of our school wherein this system will track the student and employee information/record in the database which will show if they are currently enrolled or not and if they are still an employee or not. We are using ID barcode for the gate entry to monitor the status of an individual and to record it in our database for the time in and time out activity. The TIME IN will be done through first ID barcode detection of our system and automatically record the time in of that individual into our database, the second ID detection of our system will be recorded in our TIME OUT field and so on…
I want to display the check In and Checkout time fields in the portal under student table. Is this possible so that there is an automatic check in and checkout time using their ID with barcode in the scanner and save that time in the database?
I would appreciate any suggestions to make the functionality I described above to work properly.
Thanks and more power to the File Maker Pro 11 Advanced team.