Building a database on Access 2007 and having trouble selecting the primary key. The tables consists of a student table and another table where the students are checked in. I would have liked to make the Student ID the primary key, but the check in staff doesn't request that on their paper-based forms. I also thought about the making the email the key, This would mean that they would only have to use their school provided emails
Please respond, perhaps a concatenated key would work?
NOTE: The information requested from students on the form when they sign in is there Name, Email, Date, Phone