Questions tagged [master-detail]

This type of relationship closely links objects together such that the master record controls certain behaviors of the detail and subdetail record.

Filter by
Sorted by
Tagged with
3
votes
1answer
719 views

Do calculations on child records properties for master record

I am developing data model like master - Order, childs - Order items. There is master-detail relationship. Order items have quantity and price per each item. How do I create read-only field on master ...
0
votes
2answers
1k views

Master-detail relationship query all children

The Master object Custom_Opportunity__c have a master-detail relationship on Product__c. Normally there are many Product__c records under one Custom_Opportunity__c record. Every time I use ...
2
votes
3answers
261 views

Classify parent based on number of child records in a master detail relationship

I need to count the number of child records that a parent has in a master-detail relationship and based on the count, update a field on the parent. This field cannot be a formula field as it needs to ...
3
votes
2answers
543 views

Unable to create Master Detail Relationship

I have some custom object - TestObj1, TestObj2, TestObj3.... TestObj1 - Only have 2 Master-Detail fields(With TestObj3 and TestObj4 Objects) TestObj2 - I have Master-Detail with TestObj5 now Why ...
6
votes
1answer
420 views

What happens to Master-Detail after deleting (Managed Package)

When I delete a Master-Detail relationship in my managed Package Will it be replaced by a Lookup, like this Knowledge arcticle says? Will there still be a Master-Detail relationship in our customers ...
0
votes
0answers
155 views

How do I create a many-to-many relationship to the same object?

I have a need to create a hierarchy of products, where one product is the 'base' product and other products are used to make up a final item. For example the 'base' product is a chair, but the ...
1
vote
0answers
62 views

Child relation is 'not a column" in Javascript Remoting

I'm running in to an issue where an object fetched from Salesforce through JS remoting is not able to be sent back because it has a relation field. This is the setup: A function retrieves a wrapper ...
3
votes
1answer
106 views

Preventing access to detail records using CRUD

I have a custom object B that has a master detail relationship to Account. The sharing settings on Account are set to Private. Account CRUD for sys admin and user 1 is create, edit, view, delete. The ...
3
votes
1answer
28 views

Is it possible to give users view access to a master object without giving it to details of the master object?

I'm dealing with a request to make Accounts visible to all users. However, we have a custom object which is in a master-detail relationship with accounts. This custom object should not be visible to ...
0
votes
1answer
553 views

Trigger error System.QueryException: Variable does not exist

I have two custom Objects Member and Issue. Issue has a master detail relationship with member. The field called MASTER of Issue is a master-detail field that points to Member object. I'm creating a ...
0
votes
0answers
110 views

How to upsert child object with master details realationship to another customobject,which one master as opportunity

I have one custom object(named: Class__c),it has master another custom object (Plan__c). Further this Plan has Standard object Opportunity as master. I have Class.csv files which contains classes ...
2
votes
1answer
950 views

Insufficient Privilege error while creating a record

I have a Permission set to assign CRUD permission to a certain custom Object say CI__c. This is a Junction object of two other custom object C__c and I__c. While creating a new record in that junction ...
2
votes
1answer
59 views

Querying related objects

I have a relationship between objects as below: User->Contacts->Account->Parent I am trying to get the parent id using the following SOQL query: [Select user.contacts.account.parentid from ...
6
votes
2answers
2k views

profile object permissions for a detail record

When readng through trailhead salesforce I came across a line which I am unable to digest. The line says - "You can’t set profile object permissions for a detail record". What does this mean? In my ...
2
votes
1answer
550 views

Do roll up summary calculations count against the CPU limit?

Hopefully a straightforward question - if I insert/update/delete records into an object that is a detail of another object, does the server performing the roll up summaries count against the platform ...
0
votes
1answer
44 views

N>Help with Passing Values from one Object picklist to another Object text

I have 3 objects Contact, mList and mEvent. mList is a junction object which has master-detail relationships to both Contact and mEvent. The mEvent has a picklist field called Group_Level__c (values 1,...
1
vote
2answers
2k views

Unable to create Master-Detail relationship field

I am configuring a many-to-many relationship between custom object and Contact. For this purpose I created a junction object. Next, I have to create 2 Master-Detail relations. One for custom object, ...
3
votes
0answers
516 views

Re-parenting Master-Detail relationship in managed package

I have installed a managed package in my org and unfortunately one of its master detail field(of one object created by managed package) is not allowed for re-parenting. i.e., "Allow reparenting" ...
4
votes
2answers
1k views

Is it possible to query the lookup object fields of child object?How to do it?

We have a parent object say ParentA with its associated child object as ChildA with a custom field customerName of type lookup(Account). Now I would like to retrieve AccountNumber, which is field on ...
1
vote
1answer
1k views

Lookup Filter with related fields that are more than one relationship away from the lookup object

I want to add a lookup filter for the lookup between Package Version and Release. So I just can choose Releases which are linked to the same Program as my related Package. This is not possible ...
3
votes
1answer
561 views

Look up to Master-detail through MetaData API: “cannot add master-detail relationship due to existing data rows”

Trying to change the existing relation between A(Parent) and B(Child) from Look up to Master- Detail. Deploying "B__c.A__c" using ANT. Ran a query on B and made sure all B__c.A__c is populated (As ...
1
vote
1answer
2k views

Call Child Object Fields Using Visualforce for Master-Detail Relationship

I am attempting to create a visualforce table section on the Account object. The Card Spend object is a child via master-detail to the Account object. I keep getting "Error: Invalid field ...
0
votes
2answers
1k views

Delete trigger error message on deleting a Master object record

I got two objects Business_Unit__c and Project_Portfolio__c having Master detail relationship and the junction object is, Business_Unit_Project_Portfolio_Lookup__c. I want to display an error message ...
0
votes
1answer
36 views

Detect if related list exceeds a specific number

I have two related objects example Teacher and Student. Inside my parent object Teacher I have a field maximum_number_of_student.What I want is that if I add a new student the code will check if I ...
3
votes
1answer
866 views

Unable to query child record through inner query

I have custom objects called 'Project' and 'Status Report'. Project is a parent and Status report is child in a master detail relation ship. With in trigger i wrote below query and getting the below ...
0
votes
0answers
47 views

Create & Retrieve Nested Records with iOS SDK

How can I create and retrieve nested records with the iOS SDK? Is this even possible? I have 2 objects with master-detail relationship and I'd like to be able to create and retrieve them in one ...
4
votes
1answer
1k views

Any reason not to use Lookups instead of Master-Details for Junction object?

To build n-m relationships one needs a Linker/Junction object with two references. The Salesforce documentation recommends two Master-Detail relationships. Is there any reason why not to use two ...
0
votes
1answer
420 views

Can a master-detail relationship be added to an object deployed in managed package?

I have been trying to find out how adding a new master-detail field to a released object (Object released in SF Managed Package), would impact the upgrade process. As far as adding master-detail ...
0
votes
1answer
45 views

Is there a way to update a <apex:detail> in a visualforce page with a custom save extension?

We have a VF page that were using, and we are displaying the related lists with the standard tags. Is there anyway we can use a save button feature that can go through and get the related records and ...
7
votes
1answer
2k views

How to implement Lookups in Lightning Components?

Assume you have a Lookup or Master-Detail relationship defined in the metadata and now you need a simple UI. In Visualforce lookup-controls on the UI run out-of-the-box using <apex:inputField ... /...
1
vote
0answers
91 views

Hide Related list on parent Page layout for users not in Opportunity Team

I need to hide related list on opp page layout for users who are not an opp Team member. The related list is a custom child object XYZ[Detail] of opportunity[Master]. How to implement it ? Please ...
1
vote
2answers
1k views

How to prevent trigger firing on the detail object when master object is inserted/updated

Hi I have 2 custom objects and have a master-detail relationship between them. Master : Certification Slot Detail : Certification Slot Detail I write a trigger on Master object for a ...
3
votes
1answer
7k views

Inner SOQL child to parent query

I have written the below parent to child inner query which works : List<master__c> masterObj = new List<master__c>([Select id, (Select ID FROM detail__r) FROM Master__c]); Which ...
2
votes
2answers
88 views

Auto Update Child Relation

Suppose I have an Appointment Object, which has Date, Specialization (picklist), and Patient(Master object-record type of standard object, Contact) I have another object, Visit, which also have the ...
0
votes
1answer
480 views

External Lookup Relationship

I want to create a master detail relation ship on my contact. But instead of master detail i am able to see External Lookup Relationship. what is the use of External Lookup Relationship, and where is ...
1
vote
1answer
94 views

Compare two parent objects

I have a junction object which has a master detail relationship to account and market. This junction object can only be created from account. When user clicks new, Account will already be prefilled ...
2
votes
1answer
185 views

Restrict access to sibling records (in community)

I have a sharing/permission issue I cannot work out simply. My structure is a top-level object called "Project", which has a Master-Detail (because we need roll-ups) to a child called "Assignment" ...
1
vote
2answers
87 views

System.NullPointerException parent child relationship

I have a child object of Parent Account name Vendor . I want to create multiple vendor on one account record. I have created master detail relationship between these two. When i want to save(...
2
votes
1answer
42 views

how to create a salesforce rollup field thats not on a master record in pro edtion

I have a object called key account with all the accounts that belong to this key account connected - the connected accounts have a sales total field which i what to add into a total on the Key account,...
5
votes
2answers
163 views

How to denormalise a Master-Detail relationship

Contacts have Specialities (skills) to sell so I have a Master-Detail from Contact to Speciality. We sell Product (1/2 day, full day) for those Contacts so the Product has a lookup to the Contact. ...
1
vote
2answers
662 views

SOQL query, Master detail relationship for custom objects

I have to object Student and Student Object, based on student id passed throug query string I am retriving Student data using query, I have observed that, for the Student detail field the id is ...
3
votes
2answers
154 views

Dont see Master-detail relationship type field on Entitlement object

Why cannot I see Master-Detail Relationship as an option when I try to create a new field in Entitlement object? (See image)
2
votes
2answers
2k views

Can Many to Many relationship be achieved using lookup relationship?

My question is... We normally create master-detail relationship to achieve many to many relationship. Instead of using master-detail relationship on junction object can i use lookup relationship to ...
0
votes
4answers
2k views

query flat list of records including parent and child fields

I have two custom objects in a master detail relationship where Proposal is parent and Question is child. I need to create a page where all the questions in the DB are shown along with certain data ...
1
vote
2answers
1k views

Referencing a Custom Field in a Master-Detail Relationship

I have a new custom object (let's call it fancyobject) that I want to have use Accounts as parents (i.e. there will be many fancyobjects for each account). The purpose of this is to upload data from ...
5
votes
2answers
494 views

Convert SQL query into SOQL query

I've been trying to figure out how to turn this SQL query into a SOQL query. Every time I think I am getting better with SOQL something comes along and erases that thought. Account is the parent ...
3
votes
2answers
1k views

Can Conga Use One Template Multiple Times in one solution?

We have to produce an official document from information contained in two custom objects that have a master-detail relationship. I can have one template for the master object and another template for ...
1
vote
1answer
128 views

Master details relationship

In the master Details relationship If the parent recors is deleted child record is also deleted right . My requiremen is if parent record is deleted child record does not deleted . so how can i ...
4
votes
3answers
25k views

How many master-detail relationships per object?

All I see online is that each object can have 2 master-detail relationships, but on the Salesforce App Limits PDF : https://na5.salesforce.com/help/pdfs/en/salesforce_app_limits_cheatsheet.pdf It ...
1
vote
3answers
442 views

Apex update trigger - updating Detail Fields

I have a situation where I have a two objects called Premises and Location. I have a master detail relationship from Premises to Location. I want to write a trigger so that whenever a recored is ...

1
3 4
5
6 7