Updating data field in a TBL gen. by a change within a seperate TB

G

Guest

This is going to be wordy, sorry.

I may be going about this all wrong and if so please suggest better options.

I have a table for employee information. Included along with others is a
field for Employee salary. I have a "Change of Status" table where I want to
keep up with the history of changes. I want the "Salary" field from the
employee table to auto update when a change is made in the Change of status
table for a salary change.

Example:
Table-Employee: Field-Salary: Value - $10.00
Table-COS:Value from $10.00 Changed to $20.00
Result
Table-Employee: Field - Salary: Value - $20.00

Suggestions or guidance appreciated!
 
L

Lynn Trapp

There should not be any need to store the current salary in both tables. If
you have a field to link the Employee table with the ChangeOfStatus table,
then you can always use a query to get the current salary.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to display a query as a subform? 1
Update field in table 5
Storing Calculated Values in a Table -- BAD IDEA? 7
change values in a form based on other values 4
Employee Time Tracker 2
Change field data type in table 2
How to use a combo box in a bound form? 3
Create a macro to change a value in a record 1

Top