I am the administrator for an HR database, and am struggling on how to keep the Line Manager/Direct Report relationship up to date. Line Manager information is held as a value on the child table detailing an employees job(s). But what do I do when a line manager moves/resigns and leaves one or more of his direct reports "orphaned"? Has any body else solved this problem?