This might sound silly but i am confused as to how to link the two tables together and my question is specific to mysql and database table design. I have 2 tables . The first table is pr_resignation_requests and the second table is pr_exit_checklists. Now foreach row in pr_resignation_requests i have to link each row in pr_exit_checklists. Scenario : when a person resigns from a company there will be a exit checklist which the company admin adds from the backend into pr_exit_checklist table. Now for each resignation request from any employee there will be one checklist with many items in it and mails and notifications have to go to each person responsible for the job i.e for each item. Now i want to link these tables somehow. I have attached an image for better understanding. One is my pr_resignation_requests table, for which each row in pr_resignation_requests to be linked to many rows of pr_exit_checklists. What i mean is any number of checklists can be added and any number of resignations. How to link these together and display them as a single checklist for each resignation request. How to solve this kind of a problem? This is pr_resignation_request table 
And foreach item in the above table (Now there is only on item) . Link the below table which has multiple items.
The view should look like the below Screenshot explaining the process.
For the manager: Please look at exit checklist




