Welcome to the community, @Mary_Going2!

You’ve done a wonderful job of structuring your tables so far to accommodate your “many-to-many” relationship!

The changes that you’ll want to make are these:

1. In your offerings table, delete the “Instructor 2” field altogether.



2. Rename your “Instructor 1” field to just be “Instructor”.



3. Then, for every record in your offerings table, you will create 2 records — one record for each instructor.

In other words, each record in your offerings table will act as a “unique intersection” of Class Name + Instructor + Date.

ScottWorld: Thank you for this suggestion, but allow me to clarify: these are not two sections of the same class. The same class has two instructors who teach together. Two instructors, one class.

Yes, I understand. If you want to group each instructor separately & track each instructor separately, then the instructors need to be separated out as separate records.

However, if you only want to see 1 record representing each offering, then you would need to create another table for “Offering Instructors” — and each offering from the “Offering” table would link to 2 new instructor records in the “Offering Instructors” table. So, in that new “Offering Instructors” table, each record would represent the intersection of 1 offering + 1 instructor.

So, regardless of which table methodology you choose, each instructor will ultimately need to end up in its own individual record in that particular table — if you want to group your instructors individually.

Alternatively, if you don’t care about grouping instructors individually, but you’re okay with grouping instructors “as a pair of 2 instructors”, then you would just delete the “Instructor 2” field, put both instructors into the “Instructor 1” field, and group by the “Instructor 1” field. Then, you’ll get groupings by pairs of instructors.