I have three tables. Student, Class, and StudentClassMap (many to many) that are laid out like so:
Student: SID - PK Student Name Class: CID - PK Class Name StudentClassMap: SID - FK | PK CID - FK | Grade
Now I want to make a form based of Student with a subform that shows all of their classes and the grades in those classes. I can easily do this by selecting the student table and going to Create Form. Now the subform that is auto generated just shows the CID and Grade. So to pretty it up I created a query that returns SID, Class Name, and Grade and set this as the source for my subform.
So now I have a form with the info about the student and a subform showing the Class Name and Grade for the class. I can easily add new Students and change the Grades for the classes each Student is already in. My question is how can I make it so I can add students to classes from this form. When I try to enter a class name in the subform I get an error that says I can not edit this value.
Note: I'm not trying to create a new class, the class exists in the class table... I just want to be able to add it to my subform on the student form.
Ideal situation would be for the Class Name column of the subform to be a dropdown of the Class Names that exist in the Class table.
Let me know if that makes sense.