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 7 years, 11 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());
      }
      }

    • [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

    What Sets Salesforce Apart as the Top CRM Choice?

    What Sets Salesforce Apart as the Top CRM Choice?

    Blog in Salesforce

    In today’s competitive business landscape, choosing the right Customer Relationship Management (CRM) system is crucial for an organization’s success. With a multitude of CRM options…

    AppExchange, community, CRM, Customer 360, Customization
    Kizzy Consulting May 3, 2024
    812  Views
    Salesforce Spring 21

    Top Picks From Salesforce Spring '21 Release

    Blog in Salesforce Releases

    The all-new Salesforce Spring '21 release is right around the corner. This is an exciting time for all the Salesforce developers, administrators, and consultants. We…

    Appointment Assistant, Best Practice, Campaign, Campaign Cloning, Campaign Cloning Button
    Apphienz Mar 12, 2021
    2,401  Views

    3 Ways Salesforce is Driving the EdTech Industry in 2023

    Blog in Salesforce

    Salesforce is a cloud-based customer relationship management (CRM) platform that is driving several technology trends in education. The company’s products are used by millions of…

    AppExchange, Application Process, Applications, Chatter, CRM
    Apphienz Jan 6, 2023
    1,963  Views

    Popular Salesforce Videos

    Connecting to Salesforce in Outlook

    Connecting to Salesforce in Outlook

    Video in Salesforce Integration

    Bring together the two platforms you use everyday: Salesforce and Microsoft Outlook. View and work with Salesforce data directly in your Outlook inbox, create Salesforce…

    Salesforce Integration, Salesforce Lightning Experience, Email Templates, User Setup, Lightning Experience Considerations
    Prafull Jan 28, 2019
    2,624  Views
    ChargeOn Payment Processing For Salesforce: Enhance Your Salesforce Payments

    ChargeOn Payment Processing For Salesforce: Enhance Your Salesforce Payments

    Video in Others

    Do you wish to receive payments in Salesforce but are unsure how to get started? Don’t worry; we've got you covered. ChargeOn is a fully…

    ChargeOn, Salesforce Payment Processing, Salesforce Payment Gateway, Salesforce Payment Processor, Salesforce Payment Gateway Integration
    Cyntexa Sep 5, 2025
    201  Views
    Hello (Salesforce) World - An introduction to Tableau Developer

    Hello (Salesforce) World - An introduction to Tableau Developer

    Video in Salesforce Products

    Hello, Salesforce world! Curious about Tableau (the newest member of the Salesforce family), our developer platform and suite of developer tools available? Whether you are…

    Salesforce Training, salesforce, Salesforce Developers, Salesforce Video, Tableau
    Jogender Jun 22, 2020
    1,457  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.