Forum Discussion

MarkMark1's avatar
MarkMark1
Qrew Member
7 years ago

Reassign child records to a new parent

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 Replies

  • 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. 
  • Thanks Jim - seem to have had a brain fart there!! I appreciate the help