Your db needs at least 3 tables: Employees, TrainingCourses, EmployeeTraining
EmployeeTraining
ID |
TngID |
CompDate |
EmpID |
1 |
1 |
6/12/2019 |
52 |
2 |
1 |
6/12/2019 |
18 |
3 |
1 |
6/12/2019 |
27 |
4 |
2 |
7/14/2019 |
52 |
This is a junction table for many-to-many relationship. Basic relational database principle.
Two ways to handle CompDate. This can be a date field in TrainingCourses and all employees who attended that TngID course completed on the same date. Or can be field in EmployeeTraining to allow different completion dates for same training.
Build query that includes all 3 tables for output of all related data to a report.