Teaching timetable

[Mrsostrich]

I'm looking at a database where I allocate students' music lessons. Pupils do not have the same lesson each week. I have a pupil table, a tutor table and a tuition table that links the two. That bit was easy, and allows for pupils to have lessons on more than one instrument.
The next thing I added was a lesson table with an autonumber key, week number, day of the week and lesson number (1-9, lessons in school day).

Trouble is that it means that each time the head of music books a lesson he has to choose from each of those drop down, and I can't help feeling there's an easier way.

What I want to end up with is this
Fred Bloggs Piano Lesson with John Doe
Week 1, Monday, lesson 3
Week 2, Tuesday Lesson 4
Thought, comments and suggestions much appreciated.
Di

 

[robthedog]

Have a look at the attached, is this the sort of thing you mean you mean?

 

[Mrsostrich]

Thanks

Pretty much, but as you can imagine in a school we have a set number of lessons in a day, and more or less the same number of weeks in a term, and I'm trying to keep data entry down as far as possible. Yours is very similar to mine. Thanks anyway

Have a look at the attached, is this the sort of thing you mean you mean?

 

[robthedog]

I've just got back from the pub, so excuse any obvious missthinks!! Add the lesson date and time to the sessions table and this will populate the list of available sessions on the bookings form.

 

[Mrsostrich]

Sorted! Thanks

In one of those truly bizarre Access moments, the thing is now working. I'm not aware of doing anything differently, but I rebuilt the query and form and it seems fine now. I think I'll just settle for that and be grateful!

Doncha just love it?

I've just got back from the pub, so excuse any obvious missthinks!! Add the lesson date and time to the sessions table and this will populate the list of available sessions on the bookings form.