Append query or not?

jerem

Registered User.
Local time
Today, 21:59
Joined
May 1, 2012
Messages
118
Hi,
I have 3 tables: Employees, Skills and EmployeeSkills.

Each employee has a set of 40 skills that are either "not trained", "in training" or "acquired". I want to create a form with employee name and the 40 skills with either combo boxes or check boxes to select one of the three variables for each skill. The way I am planning to do is the following:

An Employee table with employee names, a Skills table with skill names and an EmployeeSkill table with the 40 skills for each EmployeeID.
Each time a new employee is created, a code runs an append query to add the EmployeeID and a set of 40 skills in the EmployeeSkills table.

Does that make sense or is there a much easier way to create this?
 
Your process sounds correct, as long as your "EmployeeSkills" table has a Record ID field, a EmployeeID field (foreign key to the employee table), a SkillID field (foreign key to the Skills table) and a Status field to store either "not trained", "in training" or "acquired". You might also want a DateUpdated field to track the data when the latest status was achieved. This datefield would default to the current date when the record was created and I assume that the status of each of the skills would be set to some default value when the records are created.

Just my thoughts.
 
I would also recommend you store a numeric code for the Status instead of strings.

The text description would be in the lookup table that is used as the RowSource of the combo.
 

Users who are viewing this thread

Back
Top Bottom