Hi first time here and just getting back into using Access. I am trying to set up a parents evening booking system. I have 3 tables: Staff, Student and Appointment. The Appointment table has StudentID, StaffId and Time fields. I can stop a student trying to book the same time slot with two teachers by making the primary key Time and StudentID but this will not stop a teacher booking different students into the same slot (and believe me some will try). I don't want to create blank slots for all the teachers which would stop this double booking so does anyone have any idea how I can prevent double bookings of whatever kind.
Cheers
Cheers