Possible to update a record in a table with the results of another tab

[Spyder757]

Ok I’ve got a table named main table.

It contains Paid Time Off (PTO) requests for all of our employees. As these people change supervisors and even departments (which they do rather frequently) I would like to go in and change the data previously entered for these people to their new supervisor and departments based on another table.

Example:

Existing Data:
John Johnson, Sales Department, Mr Supervisor

Changed to:
John Johnson, Marketing Department, Miss Supervisor

Now normally for reporting purposes I would just create a relationship between the main table and the table that lists the current status of an employee. However that is not an option in this example because I use a form to review the PTO requests in the main table and that form must be able to update the record set. Something that isn’t possible through a form looking at a query made up of two tables.

So is it possible to create an automated solution to go in, find every occurrence of John Johnson, and update his record sets to the new data?

Spyder757

 

[johnnymac43]

Unless I have missed something in your post, it seems that you need an update query to put the latest information in your main table before you view it in the form. You could run this for all employees when you open the form, or for an individual when you click a button on the form. ???

HTH

John