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?

[June7]

Yes, will save some labor. Won't have to individually select 40 skills to create records. Run the APPEND for new employee, refresh the form, then edit each skill record for the level.

Probably have to save the employee record before creating skill records. I use VBA:

DoCmd.RunCommand acCmdSaveRecord
CurrentDb.Execute "INSERT INTO EmployeeSkills SELECT " & Me.EmpID & " AS EmpID, SkillID FROM Skills;"
Me.Requery