Creating a Training Log Database

[aprunkard]

I am trying to create a database that keeps track of all of the dealership's employee training. I have multiple courses that will be completed on different dates by different employees. I thought I was on the right track but I can't get my queries to work.
I have a table made that will store the employee number, first and last name, department, hire date, and status. And I have a table that stores the training course name, trainer, and related department.
I thought I could create a querie that I could choose the course name from a drop down or that would already be present in a list and then enter the date that it was completed. But I guess I'm confused and can't quite get it to work that way.
Thank you for any and all help.

 

[PHV]

You probably need a third table with employee number, course number and date completed.
This is known to be a many-to-many (n:m) relationship.
Take a look here:

http://r937.com/relational.html

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244