Weekly school calendar
I'm trying to create a 5-lesson, 5-day calendar so that I can populate a few fields with information from a related table which has more detailed lesson plans. The information would be along the lines of Plan #, Plan Title, Objectives, Activities. My hope was that I could enter the Plan# and the related information from the plan would be filled in for each lesson. I've got it to work as far as Monday Lesson 1, but the remaining 24 lessons take on the same information.
How can I set each lesson to act independently?
Any advice will be greatly appreciated.