+ Start a Discussion
Balasubramani DhanapalBalasubramani Dhanapal 

How To Delete Master detail Field

HI All,
         I am Begginer of salesforce,I have  Create one Master field to One object(xxx) to another Object(yyyy).Now I dont want master Detail filed. So,How To Delete that master Field.??

Advance Thanks
BalajiRanganathanBalajiRanganathan

Delete all the child records (also from recyle bin), then you can delete the relation ship field in the child object.
Also if you have any rollup summary fields in the parent  you have to delete those field from the parent.

you can access recycle bin by below url
https://<your instance>.salesforce.com/search/UndeletePage
 
Anoop yadavAnoop yadav
Hi,
Do you have any Rollup Summery field on that object?
If yes, first delete that Rollup field and then try to delete the master detail field.
 
Akshay DeshmukhAkshay Deshmukh
change the field data type to "lookup" first. then delete that " lookup field".
This should solve your problem
Anil KamisettyAnil Kamisetty
Probably you should expand on what is your need. There are two options. Either you can delete the Master Detail relationship field (it shows up the Owner field on the child object automatically) or you can change the field data type (Master detail relatinship) on the child object to another type (say lookup) using the CHAGNE FIELD DATA TYPE option. If there are any dependant roll up summary fields using the master detail relationship, you would not see the Change Field Data type button. You need to delete the roll up summary field and then change the data type or delete the field itself.
Puspendra SinghPuspendra Singh
Hello,

I have two custom objects A & C (connected usined Master Detail RelationShip), parent "A" which had a rollup summary field from Child "C". I wanted to drop child object, hence deleted the rollup summary from "A". But its still not allowing me to delete the child object. The message it is giving is "This custom object is summarized by a field in another object. Remove the usage and try again." However when I check the parent object, the rollup summary is already deleted. 
Can someone tell me what could be the possible reason for this?
Andrew Tietz 3Andrew Tietz 3
I have this exact same issue. Cannot delete the master/detail relationship because of a summary rollup field that no longer exists. 
Assunta OropalloAssunta Oropallo
Hi, I've got the same problem. This is the answer of Salesforce support to solve the issue:
1. Go to Setup (Classic)
2. Account (Your object)> Fields
3. Scroll down and click on "Deleted Fields"
4. Click erase beside your filed.
Hope that this may help you! :)