Stop duplicates (1 Viewer)

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

Hi

For my parents appointments system, I use a composite PK field in the appointments table comprising:
YearGroup + Staff ID + Parents Evening Date (as long) + Time (hhnn)
e.g. 10ANO37348-1640

Screenshots:





As you can see, it also records the name of the parents attending, phone number etc. The form also allows staff to check off which parents attended or failed to attend in case a follow up is needed

assuming your time fields are datetime, and not just time then something like this will tell you if either student or teacher are already booked for a specific time

Note that Time is a reserved word and should not be used as a field name.

Note that Time is a reserved word and should not be used as a field name.

Click to expand...

I should have said that Date & Time are field captions not the actual field names which are ApptDate / ApptTime