-
Can we create a field in custom object with the master-detail relationship in Salesforce?
A custom object contains some records, now my requirement is to create a field in this object with the master-detail relationship. Can we create a master-detail relationship in this case?
-
3 Replies
-
Hello Avnish,
No, directly we cannot create master details relationship if custom object contains existing records.
Following are the steps to create to create master-detail relationship when records are available in custom object.
First create field with lookup relationship.
And then associate look field with parent record for every recordNext change the data type of the field from look up to Master detail.THanks
-
Hi
Master-detail relationship is like parent-child relationship where, master represents a parent and detail represents a child in which master object controls some behaviors of the detail object. Like whenever a Master object record is deleted then the detail object related to it also gets deleted.
So, we can't create a Master-detail relationship on existing records. To do that, we have to create a lookup relationship for that record and then convert it into master detail.
To convert a lookup relationship to a master detail the existing record should consist of valid lookup field values.
Thanks.
-
Hi,
We can't create a Master-detail relationship when the custom object already contains data. Each object is allowed to have one or two masters or up to 8 details. After converting a lookup field into Master-detail relationship, test your customreports, whether they are usable or not.
Hope this helps.
-
This reply was modified 6 years, 3 months ago by shariq.
-
This reply was modified 6 years, 3 months ago by
Log In to reply.
Popular Salesforce Blogs
Salesforce Flows | How to Loop on Multi Select Picklist Values in a Flow?
Want to Parse and Loop on the Multi-Select Picklist Values in a Flow? Parsing the Multi-Select Picklist Selected values in a Flow is required where…
Salesforce Consulting for Small Businesses: Why It Matters in 2024
Small businesses remain the backbone of the economy; however, they usually need more resources to scale efficiently. One of the significant challenges small businesses face…
How To Use Database.Stateful Interface In Batch Apex In Salesforce
1. In Batch apex Changes made by one execute do not transfer to the other execute, so we need to implement “Database.Stateful” if the batch process…
Popular Salesforce Videos
Salesforce Spring 22 Treasure Hunt for Flow | Migrate your Workflow Rules to Flows
Salesforce Spring 22 Treasure Hunt for Flow 0:00 Register for pre-release org 0:27 Flow Trigger Explorer 2:07 Auto-Layout and Freeform option as Picklist 3:00 Set…
Data Access for Apex, Visualforce, and Lightning
Apex is a development platform for building software as a service (SaaS) applications on top of Salesforce.com's customer relationship management (CRM) functionality. Apex allows developers…
How to Set Up a B2B Marketing Analytics Plus App | Salesforce
This video shows marketers how they can create a B2B Marketing Analytics Plus app, such as Marketing Campaign Intelligence or Account-Based Marketing. So to get…