Toggle Side Panel

  • Home
  • Articles
    • All Articles
    • Blogs
    • Videos
    • Infographics
  • 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
  • Marketplace
  • Advertise With Us
  • Contact Us
  • Discussions
More options
    Sign in Sign up
    • Home
    • Articles
      • All Articles
      • Blogs
      • Videos
      • Infographics
    • 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
    • Marketplace
    • Advertise With Us
    • 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 7 years, 3 months 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());
      }
      }

    • 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

    application solution

    Popular Salesforce Blogs

    Salesforce and Microsoft Teams Integration | All You Need to Know

    Blog in Salesforce integration

    The average American has 80 apps installed on their phone. Most smartphone owners use 9-10 apps per day and 30 per month. It's not so…

    App Sharing, App Switching, Apps, Attach Salesforce Records, Auto Attendants
    Sparkybit Jun 5, 2023
    1,218  Views
    Marketing Cloud Connect

    Salesforce Marketing Cloud Connect

    Blog in Salesforce Cloud Platform

    Marketing Cloud Connect allows Salesforce users to leverage the advanced marketing power of the Marketing Cloud and the customer relationship tools in Sales and Service…

    Automation, Cloud Connect, Customer Relationships, Data extensions, Duplicate Subscribers
    DB Oct 9, 2020
    3,117  Views

    How to Integrate HubSpot With Salesforce CRM: Three Options

    Blog in Salesforce integration

    The goal of every business is to drive sales. However, its success is determined by the synergy of all departments, especially marketing and sales. 52.2%…

    API, Azure, Business Needs, Complexity, Consult
    Twistellar Jul 20, 2023
    1,147  Views

    Popular Salesforce Videos

    Salesforce Lightning Development Tutorial - Lightning Components in Visualforce

    Salesforce Lightning Development Tutorial - Lightning Components in Visualforce

    Video in Others

    Salesforce Lightning Custom Component Development Tutorial for Beginners Learn how to embed lightning components in a Visualforce page. 3 Steps Add apex:includeLightning tag in your…

    Salesforce Tutorial for Beginners, Salesforce Visualforce Page, Salesforce Lightning App, Salesforce Lightning Component, Javascript
    Neha Yadav Dec 9, 2019
    8,506  Views
    Salesforce Nonprofit Cloud Explained

    Salesforce Nonprofit Cloud Explained

    Video in Salesforce For Nonprofits

    Discover how Salesforce Nonprofit Cloud helps organizations drive social change through better donor management, volunteer coordination, and streamlined operations. In this video, we'll explore the…

    Salesforce Nonprofit Cloud, Nonprofit CRM Solutions, Nonprofit Technology, Donor Management CRM, Nonprofit Management Software
    Dean Sep 5, 2025
    76  Views
    Salesforce Diagram | Salesforce Diagramming Framework

    Salesforce Diagram | Salesforce Diagramming Framework

    Video in Salesforce Stories, Salesforce Training

    Diagrams help drive key project decisions, align delivery teams, and help everyone understand where you’re going and what’s been done. Consistent, easy-to-understand diagrams are a…

    Salesforce Training, salesforce, Salesforce Video, Salesforce Learning, Connectors
    Prafull Aug 5, 2021
    1,717  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

    © 2025 - 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®.

    Try AuditMyCRM - It is a Salesforce CRM Audit tool which comprehensively scans your Salesforce org and gives you the list of errors or warnings you need to take care of.
    We use cookies to enhance your browsing experience. Please see our privacy policy if you'd like more information on our use of cookies.