Course-Lesson ID (PK)
Course ID (FK)
Lesson Plan ID (FK)
I am trying to design a form that will allow the user to select a course name from a drop down combo box and then in a subform pull down up to 10 lesson plans so that they are assigned to that course. I was able to have the course combo box in the main form display the current lesson plans already assigned to it in the subform, but when adding a new record in the subform it just stores the lesson plan i choose as a new record in the lesson plan table, not in the course-lesson table. Attatched is my db, thank you for your help and if i am unclear or have not given enough information please let me know.
do a little comparison with the old one. You'll know. I created some queries to base the forms. This is the right way to update tables with many to many relationships. Also modified some of the relationships and table design.