Update Field From Another Table

[Lee Smith]

Wonder if anybody can assist me with a staff database I am working on.

I have one table called Qualification with a names of qualifications
and qualification code i.e.
Qualification = BA
QualificationCode = 1000

I have another table which lists members of staff details, called
Qualification Table. Staff can select Qualification from a drop down
from the above table i.e. BA. When they click on that drop down I
want Qualification Code to automatically appear in another field of
this second table of the same name.

This is the SQL I am tinkering with but not getting anywhere with;

SELECT Qualification.[Qual ID]
FROM Qualification
WHERE
((([QualTable].[Qualification])=[Qualification].[Qualification]));

Any assistance would be much appriecated.

 

[Douglas J Steele]

SELECT Qualification.[Qual ID]
FROM Qualification
INNER JOIN QualTable
ON [QualTable].[Qualification]=[Qualification].[Qualification]