Reassign child records to a new parent

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
I have 2 tables, Employees and Related Managers.
I have had some employees move to a new manager - How do I delete the old Employee - Manager relationship and assign a new manager to the existing employee record?
Photo of Mark

Mark

  • 30 Points

Posted 9 months ago

  • 0
  • 1
Photo of Jim Harrison

Jim Harrison

  • 1,768 Points 1k badge 2x thumb
There is a related field on the child table. Enter the record Id of the new manager into this field and the new manager will appear in the child table. 
Photo of Mark

Mark

  • 30 Points
Thanks Jim - seem to have had a brain fart there!! I appreciate the help