Yes, this does sound like it needs a Many to Many relationship. If you make that relationship, and can make a button to create those 100 records, then it will work.
Of course, that will lead to the question of the most painless way to make those 100 records.
One way would be to make a parent record called like Survey Cycle or whatever, inherently a data gathering effort is called. Perhaps they are Semesters.
You could make the Parent as a template record by using excel to load up those 100 blank records, buy connecting them to the proper Record ID# Parents in the two parent tables.
Then use the wizard in the Application management to make a button to import those 100 blank records into any new "Semester".
