I have a small database that has 3 tables: Instructor, Certifications, Courses.
The Instructor to Certifications relationship is 1 --> M. Courses table has Course no. and description as two of the attributes. Certifications table just has the course no. as an attribute in the table.
I'm trying to set up a form based on Instructor, showing all of his/her certifications in a subform. The Certifications table contains the course no. (same as in the Course table), but not the course description. I want to pull that info out of the course table. This is the way it should be for a normalized relationship.
Problem I have is that the subform is constructed based on a query (to get course no. and course description in the subform together), and as a result, I cannot ADD a certification to the instructor through this form / subform presentation.
Any suggestions on how to set this up would be appreciated.