Hi, im designing a employee training database system for a company of 500 where it records the training details of each employee
the following are the tables created so far
Table 1. EmpDetails
Employee no(primary key)
Employee Name
Date Of Joining
Employee Subgroup
Position
Employee Email Id
Employee User Id
Table 2. EmployeeTrainingDetails
Organizational Unit
Cost Center
Employee no(primary key)(foreign key)
Employee Name
Table 3. Program Info
Program Code(primary key)
Program Description
I have a many-to-many relationship between [EmpDetails]![Employee no] and [Program Info]![Program Code]
now im confused how to save many training details attended by each employee
1. Should I create a table and store the [Employee no] and [Program Code] in new records each time whenever a employee attends a training
OR
in some other form..??
I must be able to generate reports based on
training wise(training name and list of employees attended) and
employee wise(employe name and list of trainings attended)
can someone please suggest a good method and kindly help me out.
the following are the tables created so far
Table 1. EmpDetails
Employee no(primary key)
Employee Name
Date Of Joining
Employee Subgroup
Position
Employee Email Id
Employee User Id
Table 2. EmployeeTrainingDetails
Organizational Unit
Cost Center
Employee no(primary key)(foreign key)
Employee Name
Table 3. Program Info
Program Code(primary key)
Program Description
I have a many-to-many relationship between [EmpDetails]![Employee no] and [Program Info]![Program Code]
now im confused how to save many training details attended by each employee
1. Should I create a table and store the [Employee no] and [Program Code] in new records each time whenever a employee attends a training
OR
in some other form..??
I must be able to generate reports based on
training wise(training name and list of employees attended) and
employee wise(employe name and list of trainings attended)
can someone please suggest a good method and kindly help me out.