Activity Forums Salesforce® Discussions In salesforce, can we convert Look up field into Master detail? If Yes Then How?

  • Saurabh

    Member
    April 6, 2017 at 3:07 pm

    Hi suraj

    You can convert a lookup relationship to a master-detail relationship, but only if the lookup field in all records contains a value.

    And also We can convert the lookup relationship to master detail relationship only if all the existing record has valid lookup field values.

    For better undertstanding refer to this link:http://opfocus.com/converting-lookups-to-master-detail-relationships/

    Hope this may help you:

  • shariq

    Member
    September 13, 2018 at 3:08 pm

    Hi,

    You can convert a master-detail relationship to a lookup relationship as long as no roll-up summary fields exist on the master object.

    You can convert a lookup relationship to a master-detail relationship, but only if the lookup field in all records contains a value.

    Hope this helps!

  • Parul

    Member
    September 13, 2018 at 3:41 pm

    Hi

    To convert lookup to the master-detail relationship you need to give parent record on all child records. This is because a master-detail relationship does not allow for 'orphaned' child records. Once you have a lookup with each child having a parent than you can go back and convert the lookup field to a master-detail.

     

    Thanks

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos