Tracking Employee Training

[velcrowe]

I am tracking training for employees. I have a database that keeps track of the dates a particular training was taken. Employee training is ongoing from year to year. I have an Employee Training with a subform showing only the specific employee's training. I need a help with a few things. I need to keep track of training by the year. If I enter 2006 dates it will show in one line, if 2007 dates, another, all the way across the list of training classes for an employee. I also only want to limit a person enter more than one date for a particular class for a calendar year...Are these things possible. I have attached the database. Please help, make changes and suggestions. Thank you so much in advance.

 

[mhartman]

Hello

You have a structural problem with your design

I have enclosed an example of the way this type of problem should be approached. More work would be needed to finish. It has the basic normalizations applied to it.
Regards
Mark

 

[velcrowe]

I see the diffences. Originally, I had only yes/no boxes. Can you direct on how to reflect the date in a subform. I am trying to show the employees training history on the subform with dates. I know I can produce it on a query and report. I would like to see an employee's training history, because they take the same classes each year, such that I can see what date the employee took track-safety this year, last year, and the year before. I would like to see that for all the classes for the employee on the subform of the "Employee Training" history form. Your guidance is most appreciated. Thank you

 

[mhartman]

Hello:
Enclosed is the example for the date in the subform
Regards
Mark