Toggle Side Panel

  • Blogs
  • Consultants
    • Salesforce Product Expertise
      • Top Salesforce ConsultantsTop Salesforce Consultants
      • Marketing Cloud ConsultantsMarketing Cloud Consultants
      • Service Cloud ConsultantsService Cloud Consultants
      • Experience Cloud ConsultantsExperience Cloud Consultants
      • Analytics Cloud ConsultantsAnalytics Cloud Consultants
    • Salesforce Industry Expertise
      • Non-Profit Cloud ConsultantsNon-Profit Cloud Consultants
      • Financial Service Cloud ConsultantsFinancial Service Cloud Consultants
      • Health Cloud ConsultantsHealth Cloud Consultants
      • Commerce Cloud ConsultantsCommerce Cloud Consultants
      • Manufacturing Cloud ConsultantsManufacturing Cloud Consultants
    • Salesforce Experts by Location
      • USATop Salesforce Consultants in USA
      • IndiaTop Salesforce Consultants in India
      • AustraliaTop Salesforce Consultants in Australia
      • United KingdomTop Salesforce Consultants in UK
      • CanadaTop Salesforce Consultants in Canada
  • Webinars
  • Contact Us
  • Discussions
More options
    Sign in Sign up
    • Blogs
    • Consultants
      • Salesforce Product Expertise
        • Top Salesforce ConsultantsTop Salesforce Consultants
        • Marketing Cloud ConsultantsMarketing Cloud Consultants
        • Service Cloud ConsultantsService Cloud Consultants
        • Experience Cloud ConsultantsExperience Cloud Consultants
        • Analytics Cloud ConsultantsAnalytics Cloud Consultants
      • Salesforce Industry Expertise
        • Non-Profit Cloud ConsultantsNon-Profit Cloud Consultants
        • Financial Service Cloud ConsultantsFinancial Service Cloud Consultants
        • Health Cloud ConsultantsHealth Cloud Consultants
        • Commerce Cloud ConsultantsCommerce Cloud Consultants
        • Manufacturing Cloud ConsultantsManufacturing Cloud Consultants
      • Salesforce Experts by Location
        • USATop Salesforce Consultants in USA
        • IndiaTop Salesforce Consultants in India
        • AustraliaTop Salesforce Consultants in Australia
        • United KingdomTop Salesforce Consultants in UK
        • CanadaTop Salesforce Consultants in Canada
    • Webinars
    • Contact Us
    • Discussions
    Close search

    Activity › Forums › Salesforce® Discussions › Can we insert parent and child object record in single DML statement?

    Tagged: Account, Contact, Database, DML Statement, External ID, Parent Child Object

    • Salesforce® Discussions

      Can we insert parent and child object record in single DML statement?

      Posted by Himanshu on April 14, 2016 at 7:33 AM

      Can we insert parent and child object record in single DML statement?

      Avnish Yadav replied 8 years ago 4 Members · 3 Replies
      • Account
      • Contact
      • Database
      • DML Statement
      • External ID
      • Parent Child Object
    • 3 Replies
    • Naman

      Member
      April 14, 2016 at 7:38 AM

      Try something like below: Note that reference field must be external id field on parent object. Here i have used SLASerialNumber__c  as external id field.

      Contact con = new Contact(lastName='bhardwaj');
      con.Email = 'naman.bhardwaj@test.com';

      Account accRef = new Account(SLASerialNumber__c='12');
      con.Account = accRef;

      Account acc = new Account(Name='namanTestAcc', SLASerialNumber__c='12');

      Database.SaveResult[] results = Database.insert(new SObject[] {acc, con});

      for (Integer i = 0; i < results.size(); i++) {
      if (results[i].isSuccess()) {
      System.debug('Successfully Created ID: '+ results[i].getId());
      }
      }

    • [adinserter block='9']
    • Parul

      Member
      September 7, 2018 at 4:24 AM

      To insert the parent-child object record in single DML statement as follows:

      Inserting Custom objects (Parent and Child) records in a Single DML Statement:
      here assume Parent__c and Child__c is a custom object:
      create a External Id in Parent__c object called Parent_Ref__c.

      Child__c c = new Child__c();
      c.Name = 'ChildRecord1';
      Parent__c parentReference = new Parent__c(p.Parent_Ref__c = 'abc1234');
      c.Parent__r = parentReference;
      Parent__c p = new Parent__c();
      Name ='TheBlogReaders';
      p.Parent_Ref__c = 'abc1234';
      Database.SaveResult[] results = Database.insert(new SObject[] { p, c });

       

      Thanks.

    • Avnish Yadav

      Member
      September 7, 2018 at 10:05 AM

      Hello,

      Yes, you need to make one field as an External id on your parent object.

      Thanks.

    Log In to reply.

    • Public
    • All Members
    • My Connections
    • Only Me
    • Public
    • All Members
    • My Connections
    • Only Me
    • Public
    • All Members
    • My Connections
    • Only Me

    Popular Salesforce Blogs

    How is Salesforce SMS Pricing Helpful in Improving your Sales Strategy?

    Blog in Others

    Seamless communication acts as a catalyst to ensure enhanced sales and marketing for your business on a continued basis. It is undoubtedly a great tool…

    Automated Follow-Ups, Boost Sales Strategy, Business, Campaign Effectiveness, Challenges
    360 SMS APP Dec 11, 2023
    1,955  Views
    Control Salesforce Lightning Tabs With Next & Back Buttons

    Control Salesforce Lightning Tabs With Next & Back Buttons

    Blog in Coding and Scripting, Lightning, Salesforce Implementation

    Hello, In this post, we are going to create a sample lightning component to control <lightning:tab> with Next and Back buttons. In this code we…

    Custom Component in Salesforce, Salesforce Customization, Salesforce Lightning, Salesforce Lightning Code, Salesforce Lightning Component
    Ratnakar Mar 28, 2018
    11,910  Views
    What are External Data Sources?

    What are External Data Sources? | All You Need to Know

    Blog in Others

    Salesforce is a powerful CRM platform that allows businesses to manage customer relationships, sales, marketing, and customer service in one centralized platform. One of the…

    AWS, Component Events in Salesforce, Cross-platform, Custom Objects, Customer Behavior
    Mohit Kumar Apr 5, 2023
    1,909  Views

    Popular Salesforce Videos

    Methods in Salesforce - All You Need to Know

    Methods in Salesforce - All You Need to Know

    Video in Salesforce Apex

    Learn All About Methods in Salesforce. Watch this video and do let us know if you have any doubts or concerns. What is a Method…

    Salesforce Training, Salesforce Tutorial, Salesforce Apex, salesforce, Apex
    SFDC Sep 16, 2022
    3,274  Views
    How to Connect to External Data | Salesforce

    How to Connect to External Data | Salesforce

    Video in Salesforce Stories, Data

    An external data source specifies how to access an external system. Salesforce Connect uses external data sources to access data that's stored outside your Salesforce…

    salesforce, Salesforce Video, Salesforce Organization, Salesforce Learning, Analytics
    Pooja Oct 21, 2020
    1,575  Views
    Build Your First Custom App On Salesforce

    Build Your First Custom App On Salesforce

    Video in Others

    Lightning App Builder makes it super simple to quickly assemble apps using just declarative drag and drop features. This video covers how to upgrade a…

    Salesforce Records, Salesforce Lightning, Salesforce Apps, Lightning App Builder, Salesforce Lightning Page
    Prafull Apr 2, 2018
    2,208  Views
    Footer Forcetalks logo

    support@forcetalks.com

    • twitterx

    Quick Links

    Advertise with Us

    Salesforce® Articles

    Dreamforce 2023

    Top Salesforce® Bloggers 2023

    Top Salesforce Consultants

    Get Listed

    Company

    Contact Us

    About Us

    Privacy Policy

    Terms & Conditions

    InsightHub

    Salesforce Blogs

    Salesforce Videos

    Salesforce Groups

    Salesforce Jobs

    © 2026 - Forcetalks ● All Rights Reserved

    Salesforce® is a trademark of Salesforce® Inc. No claim is made to the exclusive right to use “Salesforce”. Any services offered within the Forcetalks website/app are not sponsored or endorsed by Salesforce®.

    We use cookies to enhance your browsing experience. Please see our privacy policy if you'd like more information on our use of cookies.