If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Training Records Database
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. |
Thread Tools | |
Display Modes | |
|
|