I have two tables in Access, and need help;
I am trying to replace the values in a column in one table, with the values from another column in a different table:
for instance:
I have one table named "2016Current" which displays the employee number and current salary.
I have a second table named "VacationTable" in which I need to replace it's "current Salary" with the "current Salary" from the "2016Current" table.
the Employee number is the unique identifier in both tables. when I go to link them via relationship, it doesn't give me an option to overwrite the "Vacation Table" Current Salary with the data from "2016Current"
(This is where I wish I could do a VLOOKUP)
What am I doing wrong? It is changing some of the salaries, but not all of them; in addition, how do I leave a field in this column blank, if the employee doesn't have a current salary because they are no longer employed?