L
lpierce819
Using MSAcess2002-2003. I have 4 tables set up as follows:
Table 1 = Employee with primary key of employee no, other fields used in the
form from this table would be fname, lname, position, department.
Table 2 = Training, with primary key of TrainingID, subform fields would be
PRO-WINumber, Revision (this is the PRO-WI revision), PRO-WIName (these 3
fields are linked to table 3 below, EmployeeNo (linked to employee table),
date, completed,
Table 3= PRO-WI , PRO-WINo and Revision and PRO-WIName are the primary keys
(need all 3 because the name and No are repeated as a PRO-WI No and Name can
be listed more than once depending on the revision Example would be Assy-001
would be the PRO-WINo and Revison 1 or 2, or 3, etc, and name is ABC) The
revision will change but the No and Name remain the same, other fields are
Obsolete, Position Responsible, Training type.
Table 4 = Position (these are the job titles) a primary key is PositionID
and a position field.
What I am trying to do is based on the training table view a list of all
training requirements for a specific employee no if an employee has been
trained then the completed box would be checked. The main form would be a
form that shows the employee no, name, department, position. the Sub form
would show the training that a specific employee needs to complete based on
their employee no. it will only show PRO-WI that are not obsolete. Although
the form is based on the employee the training is based on their job title.
The reason it is based on employee no is because a number of employees move
between departments via a job transfer, so they have training that is not
just by position.
Here is where the information should go:
The training table will hold the information on the training completed/not
completed based on checkbox. New training will be pulled from the PRO-WI
table that has been added to the PRO-WI table if that training is required
based the the position the employee has at the company.
Thank you for any assistance
Table 1 = Employee with primary key of employee no, other fields used in the
form from this table would be fname, lname, position, department.
Table 2 = Training, with primary key of TrainingID, subform fields would be
PRO-WINumber, Revision (this is the PRO-WI revision), PRO-WIName (these 3
fields are linked to table 3 below, EmployeeNo (linked to employee table),
date, completed,
Table 3= PRO-WI , PRO-WINo and Revision and PRO-WIName are the primary keys
(need all 3 because the name and No are repeated as a PRO-WI No and Name can
be listed more than once depending on the revision Example would be Assy-001
would be the PRO-WINo and Revison 1 or 2, or 3, etc, and name is ABC) The
revision will change but the No and Name remain the same, other fields are
Obsolete, Position Responsible, Training type.
Table 4 = Position (these are the job titles) a primary key is PositionID
and a position field.
What I am trying to do is based on the training table view a list of all
training requirements for a specific employee no if an employee has been
trained then the completed box would be checked. The main form would be a
form that shows the employee no, name, department, position. the Sub form
would show the training that a specific employee needs to complete based on
their employee no. it will only show PRO-WI that are not obsolete. Although
the form is based on the employee the training is based on their job title.
The reason it is based on employee no is because a number of employees move
between departments via a job transfer, so they have training that is not
just by position.
Here is where the information should go:
The training table will hold the information on the training completed/not
completed based on checkbox. New training will be pulled from the PRO-WI
table that has been added to the PRO-WI table if that training is required
based the the position the employee has at the company.
Thank you for any assistance