function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
donovankruger.ax255donovankruger.ax255 

Anyone ever change a relationship from Master-Detail to Lookup, and then back again?

We need to perform a mass update of the designated Masters (Account) for thousands of Details (custom object).  However, because of the nature of Master-Detail, this is not possible.  So we are toying with the idea of temporarily changing the relationship to a Lookup, make the ID changes, and the change the relationship back to Master-Detail.

I did this in my dev org on a very small scale and didn't notice any repercussions.  But I can't help but wonder if there wouldn't be some secondary effect to changing the relationship field type back and forth for existing records with children of their own.

Has anyone tried this before?  If so what was your experience?