Form for attending Training

[Guest]

All,
I am trying to create a form to easily input into a table, employees who
attended a training seminar. Training is conducted every other week, and
the topics change.
I was trying to build a form that has the fields "Training" "Date"
"Instructor" and then a listing for each employee with a checkbox to check if
they attended. Our current form has the operator going to each employee
record and putting a one line entry in.
The table we are using is as follows:
Employee # ; Training Type; Date; Instructor; Training Title
1 ; Safety ; 5/01/06; Donalds ; Machine
Safety
1 ; General ; 5/13/06; Harold ; Operation
of Copier
2 ; Safety ; 5/01/06; Donalds ; machine
Safety
3 ; General ; 4/15/06; Smith ; Basic
Formations

I know there is an easier way, but me and my assistant have been kicking it
around for 2 days and it is kicking us around.

Thanks for your help
Carl

 

[Guest]

You need multiple tables.
Employee records all the particulars.
Course records with Title, Instructor, date, etc.
A junction table with EmployeeID and CourseID.

Betterwould be --
You need multiple tables.
Employee records all the particulars.
Course with CourseID, Title, Requirement (OSHA, Management, etc.), Interval
(one-time, monthly, annually-12 months, etc.).
Class - ClassID, CourseID, Instructor, date, etc.
A junction table with EmployeeID and ClassID.

Use a query to determine who is due by calculating interval months after
last class date for individual.