Required Access VBA freelancer for Access Database job

Hello,
I would like to share with you an idea that I have and I am trying to find someone to assist on it.
The task is related to an application based on Access and is a part of a bigger project I am trying to build.
Attached you will find a diagram I prepared explaining my concept.
Based on tutorial I have watched I don't think it will be something difficult for someone familiar with Access.
The general concept is to create new records based on combination of the records from two different tables.
I am also attaching the sample file.
If you are available and fit this job please fill free to apply.
If possible please share with me a previous example of your idea of how this can be done in the most simple way.

Skills & Expertise Required

Access VBA