I am trying to set up a database for employee training records. So far I
have set up the tables I will need:

Work Instructions : Lists all (200+) work instructions, which serve as our
main training tool, the document# serves as the primary key and 3 fields to
list the departments the work instruction relates to (most belong to more
than 1 dept. but no more than 3)

Employees: Employee # (primary key), name, and fields to list their relative
departments (all employees belong to multiple departments (up to 15).

Departments: List of departments with an autonumber field for primary key

Training Grid: Lists employee, document #, date trained and a hyperlink
field linking to a signautre sheet.

I would like to be able to create a report that shows who needs to be
trained based on the relative department and the documents assinged to it.
The problem I am running into is while the documents will only belong to up
to 3 departments, the employees may belong to all of them. The way the
tables are set up I cannot show this relationship. What would be a better
way to do this, if any? Any suggestions at this point would be helpful. I
consider myself an Access Novice so please keep any suggestions relatively
simple.