How to convert master-detail relationship to lookup relationship ,Is there any data loss ?
If A object is master of B object then if you need to change this master-detail relationship to lookup then you only need to click on setup ->
Object ---> 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 fields" trash box then you will be able to see "change field type" button.
Changes OWD setting :
If you are converting a master-detail relationship to a lookup for a custom object on the “detail” side, the organization-wide default for the object is automatically updated to Public Read/Write. Similarly, converting a lookup to a master-detail-relationship changes the organization-wide default to Controlled by Parent
Note:
1. You can convert a master-detail relationship to a lookup relationship as long as no roll-up summary fields exist on the master object.
2. You can convert a lookup relationship to a master-detail relationship, but only if the lookup field in all records contains a value.
Comments
Post a Comment