Access 2013 - Multiple Records From One Form

I've been digging around the internet trying to find a resolution for my issue with no avail, so I've turned to the experts here at stack.

My issue: I have an reasonably complicated database setup with multiple tables.

Table 1 is called StudentInfo and contains basic information, such as Names, DOB, Nationality, Language etc.

Table 2 is called Pathway and contains Educational Pathways and Units that have to be completed in each individual pathway e.g:

PATHWAY NAME | UNIT

Business Studies -| BUS1

Business Studies -| BUS2

Business Studies -| ACT1

---

I have a form that end-users will use to add these Pathways to Students. These Units must be saved as individual records against a student ID in a third table that compiles basic data from the form and is ready to receive exam grades and other info related to each unit. So the issue I face is getting MS Access to generate up to 13 records from one form.

So the third table will look like this:

Student ID# | Unit ID# | Exam Entry 1 | Exam 1 Grade | Exam 2......

ACM001234 | BUS1---| YES-------------| 39-----------------| Yes......

ACM001234 | BUS2---| YES-------------| 87-----------------| Yes......

ACM001234 | ACT1---| YES-------------| 34-----------------| Yes......

However the data the end user will select will be: Student ID#, Pathway and Exam Entry Y/N. So I need Access to do the leg-work and grab the related units to the pathway and pump them into a table.

(I know this sounds like a back-handed method to do this however, it is the way I have been instructed to do it by people on a much higher salary!)

If anyone is able to assist I will be most grateful!

EDIT: Bumping to top of list, becuase no one replied and I really need help ={