function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Wes SmitheWes Smithe 

Issue trying to create a Master Detail Relationship in Schema Builder

Hi All,

Thanks in advance and I'll try to be brief:
  1. I've created an app called Marketplace Tracker to help manage our vacation rental business.
  2. The main object is Marketplace within which the records detail the the various vacation rental websites (marketplaces) we manage.
  3. I'm currently in the schema builder adding objects / relationships in an effort to map out the app before I get down to the nitty gritty.
  4. I have a master detail relationship from the Marketplace object to another (child) object called Geographic Region.
  5. And I have another master detail relationship from the Geographic Region object to another (child) object called Country.
  6. Then I have another master detail relationship from the Country object to another (child) object called State or Province.
Now is where the (non) fun begins:

For some strange reason I'm unable to repeat the straightforward process above by creating another master detail relationship from the State or Province to another (child) object called City. Specifically, when I drag the master detail relationship on to the child object (City) the related object (State or Province) does not appear in the drop down.

Even stranger is that, as a test, I've deleted the master detail relationship between Country and State or Province only to find that I can then create a master detail relationship between State or Province and City, but then when I go back to re-create the master detail relationship between Country and State or Province (the one I deleted) the related object (Country) does not appear in the related drop down!

Any help is much appreciated. 
Best Answer chosen by Wes Smithe
Chidambar ReddyChidambar Reddy
Hi Wes,

I think that you can have two level deep of Master-detail relationship.

You can only have grand children for a parent with master-detail relationship

http://salesforcecareer.blogspot.in/2011/10/multi-level-master-detail-relationship.html

http://salesforcecareer.blogspot.in/2011/10/multi-level-master-detail-relationship.html (http://help.salesforce.com/HTViewHelpDoc?id=relationships_considerations.htm&language=en_US

I suggest you to either use look up relationships/ "Self relationships using record types(country, state, city)


Thank you 
Choose it as best answer if it resolves your issue

All Answers

Chidambar ReddyChidambar Reddy
Hi Wes,

I think that you can have two level deep of Master-detail relationship.

You can only have grand children for a parent with master-detail relationship

http://salesforcecareer.blogspot.in/2011/10/multi-level-master-detail-relationship.html

http://salesforcecareer.blogspot.in/2011/10/multi-level-master-detail-relationship.html (http://help.salesforce.com/HTViewHelpDoc?id=relationships_considerations.htm&language=en_US

I suggest you to either use look up relationships/ "Self relationships using record types(country, state, city)


Thank you 
Choose it as best answer if it resolves your issue
This was selected as the best answer
Wes SmitheWes Smithe
Thank you for providing closure! I will look into another solution.