Append query or not?

[jerem]

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?

 

[Mr. B]

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.

 

[Galaxiom]

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.

 

[jerem]

Ok! Thank you guys!