3 tables: Course, Student, Project. Project is the associative entity.
I simply used Form Wizard to link three tables together. Course(main form)-Student & Project(subform) including all the keys in the fields for both forms. Now I can't add any records in subform. It says either: "Cannot enter value into blank field on 'one' side of outer join" or "join key of table "project" is not in the recordset."