Having a problem with Update query (1 Viewer)

[JGravesNBS]

Having a problem with Update query labeled NG, the other 2 querys work OK

When I run the query in design View mode it shows 6938 records that match with no values in MemberID

There are legitimate values in employee_id in both tables

Fields are defined as follows for all tables
employee_id Long Integer
MemberID Long Integer Yes (Duplicates OK)

NG
UPDATE tblEmployeeSkills INNER JOIN [Member Info] ON tblEmployeeSkills.employee_id = [Member Info].EmployeeID SET tblEmployeeSkills.MemberID = [Member Info]![MemberID];

This works OK
UPDATE tblMemberRoles INNER JOIN [Member Info] ON tblMemberRoles.Employee_id = [Member Info].EmployeeID SET tblMemberRoles.MemberID = [Member Info]![MemberID];

This works OK
UPDATE tblEmployeeCert INNER JOIN [Member Info] ON tblEmployeeCert.employee_id = [Member Info].EmployeeID SET tblEmployeeCert.MemberID = [Member Info]![MemberID];

Any advise would be helpful

 

[JGravesNBS]

Before I run the query I performed this Function

dbs.Execute "ALTER TABLE tblEmployeeSkills ADD COLUMN MemberID Long Integer;"
dbs.Execute "CREATE INDEX MemberID On tblEmployeeSkills(MemberID);"

After further review I re-linked the table tblEmployeeSkills

and the Update query works