I am trying to design a database for a security department for a college. I want to display information for students and their guests that they check in. I want to have the guest name as the main source of information. When the guest name is found I want it to show which student checked them in and on what date. I want to be able to see each record of the student being on campus and who checked them in. The guest can be checked in by the same student multiple times so I need a solution to allow access to recognize duplicate names and information.
I would like to have a form that will allow me to input and view data at the same time. I also want the form to update both tables of information (I am assuming that I would use different tables for this to work).
I need help creating the tables so they can speak to each other correctly in their relationships. I think I need a one to many.
Please help.