You need to sign in to do that
Don't have an account?
Ab
Not available to change master detail in to lookup field
Hello,
I have a object like below, its a custom object
I dont see any rollup on this object.
I am not able to convert masterdetail to lookup,
Can anyone let me know what can be reason ?
thanks for suggestion!
I have a object like below, its a custom object
I dont see any rollup on this object.
I am not able to convert masterdetail to lookup,
Can anyone let me know what can be reason ?
thanks for suggestion!
Changing master detail relationship to look up relationship is definetely possible.If you are not using Enterprise Edition please follow the below process to achieve your requirement.
I am sure about this problem :
if A is master of B then if you need to change this master detail relationship to lookup then you only need to click on setup ->
obeject;> master detail field > Edit> now you will not be able to see button "change field type" if there is Roll up summary field on Master object so delete it first and also remove it from "deleted fied" trash box then you will be able to see"change field type" button.Once you remove it from trash box change field type will be available to you.Just click on it and change it to LookUp Relationship.
Please mark it as solved if it helps you........
Thanks & Regards,
Nagendra.P
9848950830
All Answers
Once you create a master detail relationship, you can create a roll up summary field on the master object. If you want to convert the MD relationship to lookup make sure you delete all the rollup summaries on the master object.
Best Regards,
Deepthi
If the parent object doesn’t have Roll-up Summary fields for the child object then we can convert.
Please check your parent object, is there any roll-up summary field associated with your master object.
If Parent object contains roll-up summary field first delete that field and then convert master-detail to lookup relationship.
Hope this helps you!
Best Regards,
Jyothsna
I have deleted the rollups on master detail object which correspond to the child object, but i still dont have option to convert the field.
Its strange, as i dont think it is necessary to delete all the rollups on the master object which doenst have any relation to child objects.
any suggestion ?
thanks
Changing master detail relationship to look up relationship is definetely possible.If you are not using Enterprise Edition please follow the below process to achieve your requirement.
I am sure about this problem :
if A is master of B then if you need to change this master detail relationship to lookup then you only need to click on setup ->
obeject;> master detail field > Edit> now you will not be able to see button "change field type" if there is Roll up summary field on Master object so delete it first and also remove it from "deleted fied" trash box then you will be able to see"change field type" button.Once you remove it from trash box change field type will be available to you.Just click on it and change it to LookUp Relationship.
Please mark it as solved if it helps you........
Thanks & Regards,
Nagendra.P
9848950830