I have 3 tables involved in this situation.
Individuals with a primary key of individualID. This includes name, address, and other data.
Classes with a primary key of classID. This includes the class name, credits, dates, etc.
The third table - instructors has only two fields - classID and individualID. Both fields are in the primary key. The purpose is to be able to link multiple instructors to one class.
I believe this is correct from the table point of view. I'm stumped on how to handle it on the form where classes are entered. I am guessing I need a subform, but still don't know how to make it work for varying number of instructors. Specific guidance would be greatly appreciated.