Salesforce IdeaExchange
- then -
Customization Comments
| Customization Ideas
|
Force.com Platform Comments
| Force.com Platform Ideas
Multiple Master-Detail relationships
It doesn't seem to be possible to create a chain of master-detail relationships, like this:
House -> Key Set -> Key
Using this example, I can create a master-detail relationship between House and Key Set. But I cannot then create one between Key Set and Key, as the Key Set object doesn't appear on the drop-down menu when I try to add a master-detail field on the Key object.
This means:
- I can't use roll-up summary fields on Key Set
- If I delete a Key Set, the Key objects under it won't be deleted
Please make it possible to chain master-detail relationships.
|
ColinLoretz 08/17/07 |
This would be very helpful in creating complex relationships between items. Currently, I have a workaround for deleting objects under a lookup object but you lose the relationship that provides things like roll-up summary fields. |
|
Mack 08/21/07 |
In addition, you should be able to make an object the detail of more than one Master. E.g. Contact -> Application <- Vacancy. A Contact can apply for multiple Vacancies, if either the Contact or Vacancy is deleted, so should the related Applications. Currently I can only have a roll-up summary on either Contact or Vacancy, which greatly reduces my reporting functionality |
|
BWMoon 11/19/07 |
We have a similar issue with Expense Report -> Expense Line Item -> Contacts/Line Item link We can't count the number of contacts related to a line item to split the costs associated, and nor can we make the Contact/Line Item a master-detail relationship. this leaves us with random records left if we delete a line item, and a manual work around to count the number of contacts associated with an expense. |
|
ncurham 12/04/07 |
I have this problem very often. The solution(wich is not one) is to create a simple lookup, but really not best practice. Because if I erase the parent, I will have ghosts in my salesforce data, then I have to develop a gargabe collector to erase them. Really good idea !! Thankyou :s |
|
heatherp 12/06/07 |
Yes, this also is a problem when creating custom objects. I'd like to be able to have an account as a master AND still have the owner automatically chosen. This is definitely an issue needing review! |
|
goldenfool Jan 22 |
This issue is central to our database structure - and without being able to daisy-chain master-detail relationships in custom objects, it means that having custom report types is pretty useless. Please please PLEASE Salesforce - bring in this functionality!! |
|
TimMadigan Feb 8 |
With Exception reporting requiring the use of 'roll-up' formula fields, this is a must. Using SFDC's free Strategic Account Plans, you want to see which Accounts are missing plans and which Plans are missing Strategies but right now, you can only do 1 of the 2. That's wrong. |
|
seand Feb 15 |
Yes we need deeper Master Detail relationships it appears that you cannot create another Master Detail relationship in an object that is linked to another object that already has a Master Relationship (hope that makes sense or I understood your issue). |
|
seand Feb 16 |
To eloaborate further...We need to be able to create lookups from a custom object and make the other object the "master object". This works now, however you can only have one master relationship which is not enough as we may have one Master Record called "Life Policy" but we need this object to be the master for a few other object called "Life Commission" and "Life Assured". In short we should be able to make an object have mutiple "master relationships". |
|
MrD Apr 11 |
Roll-Up Summary fields only function on Master-Detail Objects. I would like to create Roll-Up Summary fields on some custom objects, but I am unable to do so because of an existing Master-Detail Relationship. EXAMPLE: Account < (Master Detail) < Opportunity < (Look Up)< Project Management < (Look Up) Invoice(s) It would be nice to summarize multiple Invoices to their realated Project Management records. |
|
jcoppedge May 19 |
In my eyes this should already exist. +1 |
|
bhughes Jun 16 |
I agree whole heartedly with this, and am surprised that this has not already been implemented. Currently, I wish to have a summary roll up field on the Main object, but it is necessary for a Master-Detail relationship to exist between the two lower level objects, for deletion and data integrity sake. Please allow Main Object < MD - Secondary Object < MD - Tertiary Object. |
|
sfpmguy Jul 3 |
Please, please make this happen!! Concatenating fields just to make a unique name which can relate the parent is getting ridiculous.. |
|
ncurham Jul 6 |
Please, Salesforce Pimp our multi master-detail relationships ! |
|
EricB Jul 10 |
This idea is under consideration. On our platform roadmap, we call this "multi-level master detail relationships". Regards, Eric Bezar Force.com product management |
|
EricB Jul 10 |
Changed status to Ideas Under Consideration. |
|
karima_benmebarek Jul 18 |
Hi! I have two requests. The first concerns relations principals details. I'd like that a detail object can be principal. Let me explain: For example, I created a custom object called "Mission" and linked by a research relationship to a "Candidate" custom object . Mission is a detail object, and it main object is "Account". If I want to add a candidate to a mission, it will create one, it's impossible to find it in the existing database So I have "false" duplication in the candidate tab (because they are attached to different missions), SalesForce creates whenever a a new candidate to the mission even if it has the same name. The second request is about the mass data delete on custom objects which is not possible without the data loader. How can I resolve this problem with the Group Edition? I hope you can help me. Thank you in advance for your help. |
|
kenerb Aug 13 |
The need to create multi-layer relationships is a key component to being able to build comprehensive applications. In my case I have a client who has a custom Location object that is a child of the Account object. I would like to create a custom object called Providers which is for the most part a Contact type of data structure that would be a child of the Location object. This is fairly straight forward data normalization. So far I have created the Location and Provider objects which are both children of the Account object and created a lookup from the Provider object to the Location object. Besides the obvious lack of data integrity should a location be deleted without first deleting the Providers associated with that Location, what other problems and I likely to encounter. |
|
neil_wingate Aug 14 |
This is something I have been hoping would be implemented for a long time. I run into this issue all the time. I have multi level summaries that the roll up summary works very well for, however I cannot do it on some key data tables/relationship due to the m-d limit......This would be one of my top five on the wish list. |
|
willetj Aug 19 |
This is definitely something I would be keen on. We have a few objects that would fit into this criteria and it has been a great pain not being able to use roll up summary fields on these objects. |
|
harm Aug 21 |
Please merge this idea with http://ideas.salesforce.com/article/show/10091110/ |
|
jtoy530 Aug 26 |
As an added feature, it would be nice to have the option of whether or not to roll up Activities and Notes & Attachments from the child records. See this idea for more information: http://ideas.salesforce.com/article/show/10087617/Allow_Activities_to_rollup_... |
|
harm Aug 27 |
Merged Idea
originally posted Jul 30
Master-Detail-Detail(-Detail-Detail-etc)
What I truely miss in the current datamodeling for SFDC is the possibility to create Master Detail relations beyond 1 level. For example and Account with Contacts with a custom object, which has it's own detail object... right now everything beyond the first detail level has to be solved by look-up relations, which lack a lot of useful functionality (cascade delete, roll-up-summary fields etc.)
|
|
SFDC2admin Sep 16 |
I just want the ability to link Person accounts to multiple Accounts and have the accounts link to multiple persons. Have not rolled out Person accounts for this very reason. We have trainers that need to be their own person accounts, but linked to multiple business accounts. In the end I want to see under the business account all person accounts associated with that business and within a person account all Business accounts it is associated too. (Multiple linking among person accounts is also needed - members of households) |
|
alex.lares@v2sa.com Oct 5 |
SF Dev Team: This is critical to the platform. Everyone that has worked with databases for long enough quickly learn that this is one of the most fundamental things to have. It doesn't make sense to not be able to chain AT LEAST not 2 but 3 master-details. Best, Alex p.s. SF Dev Team: Please feel free to contact me. |
|
Yves_M. Oct 14 |
Merged Idea
originally posted 10/19/06
Master-Detail-Sub-detail linking capability on custom objects
Would love to be able to extend the Master-Detail relationship capability between custom objects to be extended so that a "daisy chain" could be built, such as as Master - Detail - Sub-Detail -....
Currently this is onlly possible 1 level deep, i.e. Master - Detail. From there Lookup relationships have to be used which do not cascade-delete. |
|
NetGenIT Oct 14 |
Merged Comment
originally posted 11/17/06
I am very surprised this is nto possible! This threw a major wrench into the relational database model we are bulding using salesforce!
|
|
SGB Oct 14 |
Merged Comment
originally posted 10/02/07
Same - is there any news on this?
|
|
dklanac Oct 14 |
Merged Comment
originally posted Sep 17
This posed a problem for us as well using the canned project tracking module built by Salesforce Labs. We are unable to send a notification email message back to the original account owner when a new project is created or stage is updated.
|
|
andrew_johnson Nov 13 |
This would be very useful. I hope to see it soon! |
|
andrew_johnson Nov 13 |
Would this feature also allow roll up information from the Contact object to the Account object? If this is not a part of this idea, then i'll post a new one. |
|
trs24 Nov 15 |
We have needed this capability on quite a few implementations. Any idea when it will become available? |
track comments for this idea
Please log in to post a comment
last 100 promotions:
- tbsspm
- ltd
- andreafr
- krzysztof_zych
- joe_grefenstette
- cjones613
- ottodahl
- PQS
- remmedical
- trs24
- crcochran
- jhsdca
- stephaniedorman
- natek
- 4/9/2007_21:00
- deepbluesea
- jamesan
- julianne
- gqaz126
- philsiu02
- ldaly
- jose709
- amandahowell
- ddkpe
- nikkig
- studentforce
- cken
- hpPMO
- mfrancois
- enzigma
- njdevilsfan
- garethdavies
- alexb
- citrixops
- bertie.davel02072008
- andrew_johnson
- john022
- pj100
- GranicusJay
- terry_dwyer
- daoffcierge
- aneesh_bhatia
- stokheim07172008
- energyindustryuser
- georgier
- happygirl
- manuel_dietrich
- jonathanj
- aaron_schutzengel
- kawo
- jemo86
- dlarson
- wcobbett09302008
- johnpage
- thecrmninja
- dominic_falso
- adamcoyle
- itf45043
- marc_francois
- cpayne
- JudiS
- paul_weeden
- meagan_cantrell
- jumpin
- mholley
- kwright10192007
- radliberty
- alex.lares@v2sa.com
- azhriaz
- jfromi
- kbentley
- lvidal
- elizabethcool
- EmilyLiggett
- dklanac
- copper2
- msilber
- Neil_Bradbury
- Chez
- Banner
- duncan_stewart
- charles_stucklen
- carlos_cortes
- 8/2/2007_8:31
- gemini@work
- jheitz
- adam_erickson
- mohan_srinivasan
- EddieDial800
- CTO_4_U
- megachuckmc
- pacman
- taubium
- thermonitontom
- helentegui
- frish
- ElaineNoone
- screename
- zabby_fazel
- Rainmaker
recently demoted by:
- newleaders
- admin07162008
- dbird
POST IDEA