Basically from my database, i want to create a timetable, that can be generated for every student, that shows all of the lessons they have chosen, and on what day this lesson is, every student can only choose a maxinum of 3 lessons. I only need this for one week by the way.
I've got a Query and Form with all the days and lessons listed, and my other fields are shown in my relationships. I was thinking the best solution for me would be using a report, although i was confused as how i could create a timetable that would do what i require for every student.
I have basically no experience in VB so if a solution involves using VB i would need extremley clear instructions (for dummies basically .)
Any questions feel free to ask. Thanks, Liam