Dear,
What would be the best way to update the owner of *all* related records when the ownership of a record changes?
In our case we have one specific "master" (custom) table, that has multiple one-to-many relationships; if a record in the master table changes owner, all related records in all the other tables should be changed to the same new owner...
Best solution would be something that would work "automagically" without editing when, in the future, a new one-to-many relationship is added to the master table.
Thanks,
Koen
@ChrisPiasecki thanks, I had no idea the "Assign" relationship behavior was meant for that. I was thinking too complicated while I have been using this cascade thing since long time, but never for the ownership...
Hi @KoenJanssensPD,
You'll have to go into each individual one to many relationship on your master table in the maker portal and set the relationship behavior for Assign to either Cascade All or Cascade Active. There's no "automatic" way to set all relationship behavior this way at once without doing some custom coding. I believe the behavior is set to cascade all by default though.
---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.