Thank you NeoPa for making the images view-able.
Thank you Phil for your response. I believe I see the direction you are guiding me in:
I have tables for:
students,
their homeroom sections, and
their instruction grades (per single session),
but I don't have a table for the actual periods that are taught.
The StudentSection is (displayed in the attached image) a designation provided by the district and teachers are assigned at a later date. I am able to obtain the student ID, Name, and Section assignment in a report that can be downloaded as an excel spreadsheet; and then import the data.
The tblHomeroom uses the unique section numbers assigned by the school system as the PK and has a field for the instructor's name, so that I can use the information in reports. I can also make a simple change, if a instructor is reassigned. The final field holds the period that section/homeroom attends my classroom.
i.e.
01-04 TeacherName A1
01-05 TeacherName A1
01-06 TeacherName B1
designated section #, the instructor, attends on A days, 1st period
(sections 01, 02, and 03 are instructed by someone else)
I was very excited reading your suggestion and sat down to make it happen. I made another table (ABInstructionPeriod) with the PK being the coded periods. Each period has two homeroom sections that attend, so I tried adding fields for those as well. (Even thought the data is also in tblHomeroom)
I also renamed the StudentSection to StudentHomeroom, because the intent behind it was the district assigned designation and instructor, not my teaching section.
Unfortunately, my inexperience with multiple tables and relationships is definitely showing.
Despite two hours of tinkering, I am now at the point of posting again and then reviewing the instructional videos to help me over this hurdle.
I can't seem to figure out the correct/appropriate place to add the ABPeriod information into the big picture.
Thanks again for your time and any assistance that may be offered!
P.S. I did try to make the picture view-able based on the code that NeoPa had used, but then the system told me that I was marked as spam.