How do I update one table with information from another table?

[FDA]

I am working on a data base that will be used to track pay scales. I would
like to have one table that I update annually when the new pay scales comes
out, which will, in turn, update the information for the personnel
automatically. Any help would be great.

 

[JudithJubilee]

Hello there,

This will depend on whether your employees are all on
different salaries or if employees are on set payscales.

If it is the first option:

1. Create a query based on the Personnel table.
2. Add EmpID, Names, and Salary
3. Save this query.

When you want to update their salaries run this query and
change their info in this. This will update the table.

If it is the second option.

1. You will need a field in the Personnel table that
specifies which payscale they are on (PayscaleCode).
2. Create a new table containing 2 fields:
PayscaleCode
Salary Amount
3. Link this table via the PayscaleCode field to the
Personnel table.

If the Payscales change you can just adjust this new
table.
If you want to see what Salary each Employee is on create
a table that is based on the two tables and drag Name,
Dept, etc. from Personnel and Salary from Payscale Table.

Hope this helps

Judith