I have a table of employees. There is a employee supervisor column which points to the employee record of the supervisor. So, the table references itself. The table has a dept column. if the dept of the supervisor changes, I want to change the dept for all employees that have that supervisor. I would know how to do this using SQL server, but I can't get it to work using MS Access.