What I have:
tblPersonal
-EmployeeNumber (PK)
-LName
-FName
-MI
-JobCodeID (FK)
tblJobCode
-JobCodeID (PK)
-EmployeeNumber (FK)
-JobCode
-JobDesc
frmDataEntry
-Employee Number
-LName
-FName
-MI
-sbfJobCode
sbfJobCode
-JobCode
-JobDesc
What I am trying to do:
When a new hire hits HR, their personal information is entered in the db, but not the job code. The new hire then reports to his/her supervisor who assigns a job code. I need to figure out a way to force the creation of a new related record in tblJobCode with null information when the HR rep enters the personal info.
The problem:
In my opinion, the problem lies somewhere between laziness and incomptence. There have instances where HR does not set the new record in sbfJobCode and the new hire's supervisor doesn't do it either. This presents an issue for payroll in that payscale is driven by job code. It would make my life considerably easier if the new record in tblJobCode was created automatically so I can easier determine which employees are not assigned a primary job code, as each employee should have a primary, secondary, and alternate.
Thank you in advance for your time and help. If I am not being clear enough with my description of the problem, please let me know.