Hello,
I am planning to build a training database for my team at work and would like to get design advice before I start.
What I am trying to do:.
I want to have a list of processes that are assigned to specific departments.
I want a form for employee training and what processes they need to be trained against.
So when an employee is added to the database and they are added to a department, I want a list to generate with all the processes to be trained for that specific department.
How would I go about doing this?
Should i set up a table for processes which are linked to a department. Then when I select the department for an employee to processes list.
How would I get this to work?
I do not need a step by step, just a point of direction to take.
Thank you.
Regards,
Mark