Updating a Table with Data from Another Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table of Job Codes as follows:
Job Code Job Family Number

The Job Code field is populated, but the Job Family Number field is
currently empty. I want to add a value to the Job Family Number field based
on the Job Code field by looking at another table that has these values in
them.

The other table also has the fields Job Code and Job Family Number.

In Excel I would do this through a lookup table.

Any help is greatly appreciated.
 
Have you tried building a query linking the tables and showing the field to
be updated using the query wizard, then using the option to change that
query to be an update query?
 
Back
Top