Training Database

G

Guest

I have set up a training database with 2 tables

Employee -
Employee ID
First Name
Last Name
Office
Team Coach

Course -
Course Code
Name of Course
Date Started
Date Completed

The issue that I am having is that I need to be able to pull an employee and
see what classes they have taken/not taken and vice/versa I need to be able
to pull a class and see which consultants have taken/not taken that class.

Any help? Thanks
 
R

Rick B

I would think you'd need a third table to store the course and name of
course. The second table below would become a many-to-many relationship
that includes the course code, the employee ID, and the start and stop date.

Each person who takes a class will have a record in that table including the
start date and finish date.

Employee -
Employee ID
First Name
Last Name
Office
Team Coach

Course -
Course Code
Name of Course
CourseDetials
EmployeeID
Course Code
Date Started
Date Completed


Then you can build queries to pull all the courses and employees. You'd be
able to see courses each employee had taken, as well as those they have not
taken.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top