Hello - i am new to the forum and have a question. I have the following situation:

tbl1: staffname, mgrname, skill, skillLevel
tbl2: skill, skillID

Table one has numerous records for each staffname; ex:
staffname, mgrname, skill, skillLevel
Jones Smith C++ Expert
Jones Smith C# Expert
Jones Smith Testing Proficient
Perry Hacker C++ Expert
Perry Hacker C# Expert
Perry Hacker Testing Proficient

etc....

When I add a new skill to tbl2 like Visual Basic, how do I write a query to update each staffname unique with a record or row that adds Visual Basic

ex:
staffname, mgrname, skill, skillLevel
Jones Smith C++ Expert
Jones Smith C# Expert
Jones Smith Testing Proficient
Jones Smith Visual Basic Not_Evaluated
Perry Hacker C++ Expert
Perry Hacker C# Expert
Perry Hacker Testing Proficient
Perry Hacker Visual Basic Not_Evaluated

Any help would be appreciated? How would this sql look?

I am not sure is yo want ro add (insert/append query) the skill or update an existing record.

If ass the skill to the staff when why add the records?

If the record not not exist would mean "Not_Evaluated" for that skill? If yes, then I would not add the records. I would calculate this as needed.

Also you tbl1 ( staffname, mgrname, skill, skillLevel) has some data normalization issues. This really needs addressed before going forward. Once htios is fixed, adding a skill will be much easier.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015