Wanting to Create Sign-In Database for Computer Lab
I am wanting to create a simple sign-in database using Filemaker Pro 12 Advanced. So basically I would like the first screen to just show a field where the user can either manually enter in their ID number or can scan their University ID with our barcode scanner. Upon exit of that field or by clicking an OK button I would like it to automatically check to see if there is a client account or record of that ID number and if so would take them to a screen showing them their information like their full name and what department they are in and maybe asking a few questions as to how they are utilizing the computer lab that day. Could someone guide me on what tables I should have and what type of script I would use to have it automatically check to see if the record exists or not and if it doesn't exist take them to a screen where they can create the rest of their "account"?