Discussions

Expand all | Collapse all

Reassign child records to a new parent

  • 1.  Reassign child records to a new parent

    Posted 02-05-2018 15:38
    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?


  • 2.  RE: Reassign child records to a new parent

    Posted 02-05-2018 15:45
    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. 


  • 3.  RE: Reassign child records to a new parent

    Posted 02-05-2018 15:52
    Thanks Jim - seem to have had a brain fart there!! I appreciate the help