Help with creating a sign-in database
I'm fairly new to Filemaker Pro, and just wanted to check with some experienced people about how to create a sign-in database for a local volunteer rescue organisation.
To explain more clearly, once volunteers arrive at the office - they will need to sign in using an ID number. Once they leave, they need to sign out and enter the activities they completed.
So I have set up the following system:
- For sign in, I have a page with a "Sign in" button. Once clicked, this creates a new record, and requests the users ID number. The "time in" field is automatically filled with the current time. The user receives a confirmation and then the database returns to the main menu layout.
- For sign out (this is where I am having problems) - I have the user enter their ID number and then Filemaker searches for their record and enters the sign out time and activities completed. The problem is, I don't know how to get Filemaker to select the most recent record. If the user comes in everyday for two weeks - Filemaker seems to always choose the oldest record. Does anyone know how to solve this?
Also, I'd really appreciate any tips on the structure of what I have set up, and if I have done it completely wrong?!
Thanks very much!