the answer to the question is the ERD should be a recursive relationship. There should only be two entities; Department and Manager/Employee(call the second entity what you may). Recursive nature of the table is the manager is also an employee and has employees reporting to Him/Her. I would be happy to demonstrate the data on a spreadsheet if you like. Simply reply to this thread and I will jump back on.

Good luck!

Jim(casinc815)