Apex Code Development You need to sign in to do that
Don't have an account?
Wes Smithe Issue trying to create a Master Detail Relationship in Schema Builder
Hi All,
Thanks in advance and I'll try to be brief:
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.
Thanks in advance and I'll try to be brief:
- I've created an app called Marketplace Tracker to help manage our vacation rental business.
- The main object is Marketplace within which the records detail the the various vacation rental websites (marketplaces) we manage.
- 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.
- I have a master detail relationship from the Marketplace object to another (child) object called Geographic Region.
- And I have another master detail relationship from the Geographic Region object to another (child) object called Country.
- Then I have another master detail relationship from the Country object to another (child) object called State or Province.
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.
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
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