function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
jaswanth kandagatla 2jaswanth kandagatla 2 

can we convert a master detail relationship into a lookup relationship?

ravi soniravi soni
hy jaswanth,
yes, We can.
Follow below step and find your answer.
1. Click on your desired(Master Detail Field) Field => Edit=> Change Field Type.
2. Then select Lookup Relationship and then Next and save.

let me know if it helps you and marking it as best answer.
Your one best answer give us motivation to working towards this way.
Thank you
 
Suraj Tripathi 47Suraj Tripathi 47

Hi,

Converting Relationship
To convert a master-detail relationship to a lookup relationship, we have to make sure there are no roll-up summary fields on the master object. If there are rollup summary fields we have to delete those fields to convert it. Deleted Roll-up fields should also be permanently deleted. This can only be done in Salesforce Classic since ‘Deleted Fields’ does not appear in Lightning.
To convert lookup to the master-detail relationship you need to give parent records on all child records. Then only you can convert a lookup relationship to a master-detail relationship if the lookup field in all the records contains a value.

You can take references from the below link:

https://trailhead.salesforce.com/en/content/learn/modules/data_modeling/object_relationships

https://help.salesforce.com/articleView?id=sf.relationships_considerations.htm&type=5 (https://help.salesforce.com/articleView?id=sf.relationships_considerations.htm&type=5)

Please mark it as the best answer if your queries are solved.

Thank You