I am creating a database for applicants by vacancy name.
Here is the process:
- I create a vacancy where I need to connect people involve in that position that includes the hiring managers and the applicant.
- After I connect the applicant to the position, I need to choose a template that I want to send to him so that I can check his skills.
My idea is that:
- create vacancy, after hitting next, i will go the page where i can choose or create applicant.
- after selecting the applicant or creating them, when I press the next button, i will go to page where i can see the templates.
- on the template table, there is an action button saying use this template, then after pressing it, the button will change to confirm. then after hitting confirm. This template will create a duplicate but the duplicate will be assigned to the applicants name. then will leave the original copy on the owner of the template.
The problem is that, I can connect the table 1 to table 3, but how I can connect table 2 to 1?
If this will not work, can anyone make a turn around for these please.