Normalized Tables issue with form

[KristenD]

I have attached the relationship report for my database. It has taken me a week to finally normalize correctly, at least I think, the tables for the 2nd portion of my database.

What I am trying to do with the second portion is track which training employees have had and the date they trained, as well as what document we have on file. As well as track the active employees at different job sites and as we progress further this year certain crafts will have to have advanced training.

From one table I have created 3 tables:

tblEmployeeInfo
EmpInfoID <PK> autonumber
EmpID
EmployeeType
CraftCode
JobNumber

tblOSHA (Datasheet)
OSHAID <PK> autonumber
EmpInfoID
OSHATraining
Training Date
DocumentType

tblJobs
JobNumber
JobSite

When I go to put this in a form it pops up with an IIF statement stating something about tbl.Styles and Null. There is no coding behind this as of y et.

 

[GinaWhipp]

A few suggestions on your table design...

tblEmployeeInfo
eiEmployeeInfoID - PK, Autonumber
eiEmployeeID
eiEmployeeTypeID - FK (tblEmployeeTypes)
eiEmployeeRatingID - FK (tblEmployeeRates)
A. eiCraftCodeID

tblEmployeeTypes
etEmployeeTypeID - PK, Autonumber
etType

tblEmployeeRates
erEmployeeRatingID - PK, Autonumber
erRating
erSkillID - FK (tblSkills)

tblSkills
sSkillID - PK, Autonumber
eSkill
eDescription

B. tblJobs
jJobID - PK, Autonumber
jJobNumber
jSite
etc...

B. tblEmployeeJobs
ejID - PK, Autonumber
ejJobID - FK (tblJobs)
ejEmployeeInfoID - FK (tblEmployeeInfo)

C. tblOSHA
oOSHAID -PK, Autonumber
oOSHATraining
oDocumentType

C. tblEmployeeOSHA
eoID - PK, Autonumber
eoEmployeeID - FK (tblEmployeeInfo)
eoOSHAID - FK (tblOSHA)
eoTraining Date
etc...


A. If an Employee can have more than one CraftCode then it needs to be broken out and a *joiner* table created

B. Since an Employee can be assigned multiple Jobs either at once or over time it needs to be broken out, see above.

C. An Employee can participate in more than one OSHA training activity so it should be broken out, see above.

As for you original issue, you didn't mention which form or which combo box on which form gives you the error.

 

[KristenD]

Sorry it has taken me so long to respond. I had to switch over to another project. As far as the craft code I am only concerned with the most current one in the OSHA tab. The skills tab it is tied to each inventory.

Same thing with the jobs, I just need to know the current job they are on. The reason for having them in the db is for reporting purposes. Ultimately once this is completed I will be able to run a report by job to see who has what training, if any, and what type of documentation we have on file.

Everything ties back to the employee ID but each department will only see what occurs to them so Resources will only see the skills rating for each employee. The Safety department only sees what OSHA training employees have had and what documentation has been provided to us. There is more but that is another portion that I have not yet started.

I think I figured it out. I did not use the sub form wizard to add the datasheet to the form so now it gives me now errors.