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
|
|||
|
|||
4 tables want 1 main form and subforms to update the tables
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 |
Thread Tools | |
Display Modes | |
|
|