>>but are you AUTOMATICALLY adding deptids into the intersection table anytime you add a new department<<

Not when I add a new department...only when a department is added/removed from a staff members profile.

When I said "add a department" above I meant add it to a staff member profile.