Employee Training Help
I am creating an employee training database where I can run reports and
queries about who has taken what type of course.
What kind of relationship should be created between the tables? Based on the
some of the discussions I have seen here, I have created three tables:
1: tblemployee (with employee id set as primary key)
2: tbltraining (with trainingid set as primary key).This table has no
3: tlbcompletedtraining (in this table I have employee ids with the id's of
the training courses that they have completed)
I am unsure of what kind what kind of relationships to create between the
Any help out there would be greatly appreciated....