Hi all,
I am in the process of creating an apprenticeship training matrix, essential a log of apprentices and a list of training that they are required to complete at different stages throughout their apprenticeship.
- I have a table that is a basic profile of the apprentice
- I have a table that lists all the tasks to complete throughout a four year period
My end goal is to have a form that has multiple pages: profile, year 1, 2, etc, on the yearly pages I want to list the tasks required for that year and a tickbox showing completion status.
Every apprentice has the same required tasks to complete so I need to essential assign all the tasks when a new apprentice profile (record) is added.
Can anyone help, I have the layout all sorted but I am struggling to link to table of task records to a single apprentice record
I am in the process of creating an apprenticeship training matrix, essential a log of apprentices and a list of training that they are required to complete at different stages throughout their apprenticeship.
- I have a table that is a basic profile of the apprentice
- I have a table that lists all the tasks to complete throughout a four year period
My end goal is to have a form that has multiple pages: profile, year 1, 2, etc, on the yearly pages I want to list the tasks required for that year and a tickbox showing completion status.
Every apprentice has the same required tasks to complete so I need to essential assign all the tasks when a new apprentice profile (record) is added.
Can anyone help, I have the layout all sorted but I am struggling to link to table of task records to a single apprentice record