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

Popular posts from this blog

Adding a red asterisk to required fields using label in LWC

The Developer Console didn't set the DEVELOPER_LOG trace flag on your user. Having an active trace flag triggers debug logging. You have 1,978 MB of the maximum 1,000 MB of debug logs. Before you can edit trace flags, delete some debug logs.

Salesforce: Serial and Parallel Approval