Help! (1 Viewer)

[DT]

I'm having a terrible time with this database. It's a certification database. I need the subforms to show all training available (no comboboxes). I know I'm over thinking this thing but I have hit a wall. Here is a some info about the database:

Example:
EmpID 21445
EmpName Jon Doe
DeptID 1105
DeptName Eng

Certifications Needed:
There could be many CertID per Dept
CertID 0501
0502
0503

Each CertID could have many steps. Each step has docs to read.
CertID 0501
CertStep 001 doc1 doc 2 doc3 Checkbox if trained textbox with date
CertStep 002 doc1 doc 2 doc3 Checkbox if trained textbox with date
CertStep 003...

I received a spreadsheet with a bunch of info in it and thought I might be able to use it. It looks something like this:
DeptID CertID CertStep Doc1 Doc2 Doc3 Trained Date
1105 0501 Desc 01-1 PR-1 SD-1 x 9-8-2006
1105 0502 Desc 02-2 PR-2 SD-2
1105 0503...
1122 2204 Desc 04-1 KL-1 LR-1 x 9-10-2006
1122 2208 Desc 08-1 KL-2 LR-1
1122 2209...

I imported the spreadsheet into a table. I need the above info to show for each employee per DeptID. I created a form(emp info) with a subform(dept,cert id's) and a subsubform (cert steps). I can't figure out how to refer to the above table (imported from spreadsheet) for each employee. Does any of this make sense? Any help would be appreciated.

Thanks in advance

 

[KenHigg]

If you'll set your data up in notepad with a non-proportional font and then post it in 'code tags' your post will be easier to read and more people may be inclined to respond to your question. Example:

DeptID   CertID   CertStep   Doc1    Doc2    Doc3    Trained Date
1105     0501     Desc       01-1    PR-1    SD-1    x 9-8-2006 
1105     0502     Desc       02-2    PR-2    SD-2
1105     0503     ...
1122     2204     Desc       04-1    KL-1    LR-1    x 9-10-2006
1122     2208     Desc       08-1    KL-2    LR-1
1122     2209     ...

ken