I have a lookup relationship and i am looking at ways to convert this relationship to Master Detail.

I have made sure that there are valid ids on the lookup and none of them are null. And when i try to change field type there is only option of Lookup to select. What is the process to change the lookup to master detailenter image description here


  • is the master detail relation limit on that object is full already? – Anurag Aug 10 '16 at 16:25
  • is there a way i can check that easily ? – Prady Aug 10 '16 at 16:27
  • You can check on Object definition. You can add max 2 master detail relationships on a object – Devendra Aug 10 '16 at 16:29
  • Wanted a master detail on contract object for opportunity. i dont have any master detail on contract object – Prady Aug 10 '16 at 16:35

Some objects, like User, can't have master-detail relationships associated to them, and many standard objects cannot have a custom master-detail relationship to another object. You'll also be prohibited from making master-detail relationships if you've already reached your maximum. If you're looking for the behavior of master-detail relationships on this object, you'll most likely need to implement the sharing, cascade deletes, and/or roll-up summary fields via triggers, flows, etc.

  • Its on contract object. i guess the restriction could also be on this object as well – Prady Aug 10 '16 at 16:34
  • @Prady Yes, Contract can't have custom master-detail relationships. – sfdcfox Aug 10 '16 at 16:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.