Hi everybody - I am new to this forum (joined right now after spending the last 4 hours trying to prevent double bookings)
So an insight into my database:
It is for a tutoring centre to create a timetable, invoices and register new students.
I have a lesson table which includes the following:
LessonID
Date of Lesson
Time of Lesson
Teacher
Student ID
Price
Paid
Subject
(also have a Parent, student, subject, teacher table)
- I realise I made a big big mistake by putting spaces in my field names, but unfortunately when I try changing that it messes everything else up (my forms etc, I have finished making my entire database, just have to prevent double bookings now).
My teacher isn't very good and unaware of how to do this and told me to research it. I have spent ages trying to do it and have gotten nowhere.
I want to prevent double bookings so that: Teachers cannot be booked for a different subject at the same time and date
and: students cannot be booked for a different subject and the same time and date
If not this, I want the query to show all the data where double booking has occurred.
Any help?
So an insight into my database:
It is for a tutoring centre to create a timetable, invoices and register new students.
I have a lesson table which includes the following:
LessonID
Date of Lesson
Time of Lesson
Teacher
Student ID
Price
Paid
Subject
(also have a Parent, student, subject, teacher table)
- I realise I made a big big mistake by putting spaces in my field names, but unfortunately when I try changing that it messes everything else up (my forms etc, I have finished making my entire database, just have to prevent double bookings now).
My teacher isn't very good and unaware of how to do this and told me to research it. I have spent ages trying to do it and have gotten nowhere.
I want to prevent double bookings so that: Teachers cannot be booked for a different subject at the same time and date
and: students cannot be booked for a different subject and the same time and date
If not this, I want the query to show all the data where double booking has occurred.
Any help?