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.
387
questions
0
votes
2
answers
33
views
A formula number field can't be used in rollup summary
The child object has two formula number field and when I want to create a rollup summary field on parent object, one of them is not available.
What can be the reason of it?
- 29
2
votes
1
answer
84
views
Anonymous code to run a bulk update
I have three objects, namely Tests, Grant, and Grant Contracts.
Here in Tests object I have given a lookup to Grant and Grant Contract. I have also given a lookup in Grant Contract to the Grant object....
- 43
2
votes
0
answers
46
views
Safely replace a packaged Master-Detail with Lookup
My active 1GP Managed Package app suffers from Account and Data skew (with ROW LOCKING) because we made a custom object AccountItem__c a child in a Master-Detail relation (MDR) ship with Account.
As ...
- 34.3k
0
votes
0
answers
16
views
Salesforce relationship [duplicate]
When A child object having two master detail relationship with two different parent objects. Here which parent record owner will restrict the child records ?
0
votes
1
answer
77
views
Can we create Junction object with one master-detail and one lookup field?
Can we create Junction object with one master-detail and one lookup field? What will be its security configuration in case Lookup relationship field is created first?
- 21
0
votes
1
answer
26
views
Parent Object = Guest_Master__c , Child Object = Payment_Master__c On child object I have created master detail record of Parent Object
Parent Object = Guest_Master__c
Child Object = Payment_Master__c
On the child object I have created master-detail record of parent object Payer_Details__c
I want to create Payment_Master__c & ...
0
votes
1
answer
112
views
How to get the parent id in a master-detail relationship and assign it to the child id
I am new to apex and I have created an apex trigger that will create new residents whenever a city census(custom object) is approved. The created residents is based on the contacts object's details ...
0
votes
1
answer
17
views
What does referring to a child relation of an object return?
Custom Object Maintenance_Request__c has master Detail relationship to Custom Object Vehicle__c (Child Relationship Name = Maintenance_Requests).
In the Following code
for(Vehicle__c veh : v){
...
0
votes
0
answers
22
views
Master Detail - reparenting options [duplicate]
I have a custom object Candy__c. Candy__c has an Account__c field that is a master detail to Account. I am cloning an account record and want to KEEP the old account record. Yes there will be ...
- 3,177
0
votes
1
answer
35
views
How To Access Field f of an Object A to which Object B is having a master detail relationship using Object B?
I have a Custom Object called Vehicle__c which has a Master Detail Relationship with Contact.(Vehicles owned by contacts);
Another Custom Object Called Maintenance_Request__c which has a Master Detail ...
0
votes
1
answer
24
views
Create csv of children records on parent in master-detail relationship
I have a Master-Detail Relationship.
Each Child record has a Name__c field.
I want to create a child_names__c field on Parent that is a sorted-asc csv of of each Child's Name.
Rollup-summary seems to ...
- 137
1
vote
1
answer
49
views
Sharing a detail object with external users
Issue
I have a detail object "License" that functions as a junction object between "Software product" and "Account". "Software product" and "Account" ...
- 149
-2
votes
1
answer
68
views
In report how to pull additional fields from master-detail relationship
I have an object Y with field X which is a lookup field of the same object(Y). I want to create a report that pulls many fields from my object (Y)(including field X and master-detail relational fields)...
0
votes
2
answers
113
views
Master Detail Relationship question
i have master-detail relationship between A&B object where A is master and B is child. Now when a record is created in object B by a user, it is visible by other user also. Is their any way to ...
0
votes
0
answers
33
views
How to create roll-up summary field on Master Object to display Status of most recent line item?
The relationship between the objects is Master-Detail. Object1 - Ticket | Object2 - Tasks.
I'd like to display Status of most recent Task (line item) record on Ticket Object. How can I achieve this? ...
- 11
0
votes
1
answer
54
views
Unable to create Master-Detail relationship where AccountContactRelation is the master
Im creating a master-detail field on a custom object I just created and I was wondering why this standard object (AccountContactRelation) does not appear when I want to select it as the Master...
Thx ...
0
votes
1
answer
81
views
Set predefined values from parent object while creating child object in master detail relationship
I have master detail relationship between Opportunity and Work Order. There is Work Order related list in Opportunity. On clicking 'New' in related list, I want to prepopulate some fields using ...
- 1,004
0
votes
0
answers
226
views
External Id a standard field on Custom Objects
I am writing a data migration project to take data from an external system and map it into SFDC as a hierarchical structure of custom objects using the Bulk Api 2.
The pattern is as follows:
Insert ...
0
votes
1
answer
240
views
Delete permission on child object of Master Detail relationship
I need to give delete permission for one object.
That object has Master-detail relationship with Account, and that profile has View all Permission for an Account object.
The profile has Delete and ...
- 3,004
0
votes
3
answers
491
views
How to Query all fields of grand parent record with SOQL?
I have a App__c with n number of fields.
Page__c is another custom object has few fields and a field App_Id__c which is Master-Detail to App__c object.
Field__c is another custom object has fields and ...
- 113
0
votes
0
answers
350
views
Two users with the same profile but able to see different field
I have two users with the same profile but they should be able to see only their own field. In my case, I have two accounts fields. Account 1 and 2. User 1 will be able to see account field 1, same ...
- 23
0
votes
2
answers
360
views
Do we need Edit access on Parent record if they have Rollup Summary
I have a child object which has a Master detail relationship with Account. There are some rollup fields on account.
Now whenever I'm trying to create a new child record using a user who does not have ...
- 3,004
0
votes
1
answer
170
views
Bulk API v2.0 Master Detail Record Field Import Failed
I am going to trying and summarize this as well as I can.
My standard object "Contact" has an external Id field called "Client ID". This is the unique identifier for a contact/...
- 23
1
vote
1
answer
32
views
Error creating rows in a custom history table
We are in need of creating History Tracking for the Quote object. I am trying to make this work like the History Tracking that Salesforce already has coded in the system for Opportunities (create a ...
- 13
4
votes
1
answer
429
views
Do Master Records (in a Master-detail Relationship) Get Locked?
Suppose the following:
There's a master-detail relationship between two custom objects
There are no roll-up summary fields on the master object
There are no declarative automations or Apex triggers ...
- 664
0
votes
1
answer
955
views
Access child object fields on custom classic email templates
In my use case, I have 2 objects called 'Object A' and 'Object B'. 'Object B' contains a master-detail relationship to Object A. I have an email alert which has been set up on 'Object A'. In the ...
0
votes
1
answer
432
views
Rollup summary field between multiple objects
I have 4 objects: Contact, Attendee, Events, and Event Category. I want to create a rollup field on the Contact object to count total number of Events (where event category = Training) attended by ...
- 97
0
votes
1
answer
35
views
Why do we need two master-details relationships while creating many-to-many
I'm preparing to SF Dev1 exam and noted that they suggest using MD instead of Lookup. What can be the reasons using this approach?
- 687
0
votes
0
answers
57
views
How to skip a mandatory field in custom layout when you create a new record
Background;
I have created a custom object A which has a Master-Detail relationship field to a Parent object (Let's say it's field F).
I also created a custom layout for the object A.
Problem
When I ...
-1
votes
1
answer
67
views
Check constraint in master-detail [closed]
Is it possible to implement 1:1 relation between master and detail. I'm not able to create neither rollup summary on master nor trigger on detail
- 687
0
votes
2
answers
55
views
Java Devlopment: How to Map Detail Objects to Their Master Object in Master-Detail Relationships
I have a Salesforce project in which I will be automatically popualating custom SObjects from a Java app. This will be done by pulling data down from a database, parsing it (including a JSON payload), ...
0
votes
0
answers
36
views
Why Opportunity object has special features than others [duplicate]
I need a little explanation on Opportunity object. I was wondering Account and opportunity objects are in Lookup Relation but acting as Master-Detail. Also in workflows, we can update Account Records ...
user85512
0
votes
0
answers
72
views
What is the recommended way to filter a child object from the parent object through SOQL
I have a child object that I need to create which would be related to Opportunity. Let's call it RepPay. I wanted to know what is the best way to create this relationship for querying purposes which I ...
- 1
0
votes
1
answer
185
views
Internal Salesforce.com Error in while inserting records of Master - Detail Object
I have a scenario where I need to insert more than 60 detail records of a single master. In the same instance I have to insert the master record get the ID and then insert 60 different details of the ...
- 140
0
votes
1
answer
523
views
To display an error message when a record is submitted for approval using apex trigger
Please help me with this code, Writing a Trigger to display an error message on Opportunity_Support_Request__c record which has no OSR Product and if it is submitted for Approval(by clicking on Submit ...
- 9
0
votes
2
answers
650
views
Update Parent Object Field using Apex Trigger on Insert Child Object
Question: How can I update a parent field with some information I parse from the child?
Invoice__c is the Master/parent and LineItem__c is the Detail/child object.
My code so far: (See WHAT I WANT TO ...
- 3
0
votes
1
answer
28
views
Assign child to parent with objects in the same method
I need to assign the child of a parent record that is in the same method. Would I have to insert it before assigning the Id to a parent?
//Add row method for both lists
public ...
- 87
2
votes
1
answer
421
views
Master-detail relationship SOQL query works in dev console but not Apex
I have a junction object that links a meeting note to contacts who attended the meeting. It is a master-detail relationship.
How do I get the name of the linked contact too in Apex?
It works in ...
- 322
0
votes
1
answer
113
views
Authentication required error when inserting records with master-detail relationship on force.com site
I've got a force.com public site that is accessible without user login via guest user.
For some strange reason, this site works 100% when it is inserting a record alone, but throws an error when ...
- 87
1
vote
1
answer
76
views
How to update related record with parent field in VF custom controller
What I have in my custom controller is an assignment when a user inputs a value for a certain field, the field for its parent object will update as well.
For example.
User inputs the school for a ...
- 87
0
votes
2
answers
749
views
Need help with Validation Rule in Master Detail relationship
I am new to Salesforce and need help in writing a validation rule.
I have a Master object that can have multiple child objects.The child object has a field 'Type' with value lets say X and Y. If one ...
- 1
0
votes
1
answer
692
views
Master - Detail relationship New record from related list
I have an object which has a master detail relationship with Account object. I want when creating a new record for this new object from the Account related list, to suggest the current account and not ...
- 815
0
votes
1
answer
39
views
Deny or allow the creation of a new record if in the parent object (records) - the field of the picklist type has the status "closed" or "active"
I have two objects: Training and Participant with a master-detail relationship (Training (master), Participant (detail)).
When training is "canceled" (Status (Picklist) field selected ...
0
votes
0
answers
281
views
Cannot Create Lookup Relationship on Custom Object
I'm trying to create a lookup relationship field however it's giving me an error saying it cannot create a Master-Detail relationship, which is not what I selected. Is there any reasion for this ...
- 17
0
votes
0
answers
216
views
stripinaccessible stripping fields for system administrator
I have a generic function to validate CRUD before DML which uses stripInaccessible().
public static SObjectAccessDecision validateCRUD(AccessType access, List<SObject> records, Boolean ...
- 155
1
vote
1
answer
200
views
Soft-Delete in Salesforce for All data[For Auditing]
We have a requirement to maintain every data(even deleted also) for approx 10-15 yrs with its Audit history. We have Salesforce-shield is enabled so maintaining Audit data is taken care of by it. ...
- 2,761
0
votes
0
answers
85
views
How to populate count/sum of certain fields (Number datatype) in a custom object?
Custom object "A" should have certain fields like "Number of Contacts with training date" and "Number of Contacts Last Trained". Currently "A" has look-up ...
- 3
0
votes
1
answer
146
views
Add products on custom objects vs. junction object - please help!
My organization awards scholarships. I have two objects: scholarship and recipient. I need to be able to track the awards that each recipient receives, without creating a new record each time the same ...
- 87
0
votes
1
answer
22
views
How to display master variables in visualforce
I have a master-detail relationship with master object Service__c and child object Service_Task__c. The relationship API is Service_Task__r. I am using a custom controller.
My visualforce page is ...
0
votes
1
answer
581
views
How to insert new records into the custom object using Data Loader which has "Master-Detail" relationship with Account?
I have an Account object and a custom object "B" where Account is Master and "B" is Child. I already have Account data and I am looking for inserting records in "B" using ...
- 3