[SalesForce] Create Multiple Child Records from Parent Record

I have two custom objects: Parent (Parent__c) and Child (Child__c). The goal here is for the user to click a button on the Child Related List and enter data in input fields to create new Child records.

Here's my code:

Controller:

public class AddingChildController {
Id parentId;
public List<Child__c> childList {get;set;}
public Integer rowNum{get;set;}

public AddingChildController(){
    Id childId = ApexPages.currentPage().getParameters().get('childId');
    childList = new List<Child__c>();
    childList.add(new Child__c());
}


public void insertChild(){
    insert childList;
}

public void insertRow(){
    childList.add(new Child__c());
}

public void delRow(){
    rowNum = 
Integer.valueof(apexpages.currentpage().getparameters().get('index'));
    childList.remove(rowNum);
}
}

Visualforce Page:

<apex:page controller="AddingChildController" >
<apex:form >
    <apex:variable var="rowNum" value="{!0}" />
    <apex:pageBlock >
        <apex:variable var="rowNum" value="{!0}" />
        <apex:PageBlockTable value="{!childList}" var="int">
        <apex:facet name="footer">
            <apex:commandLink value="Add" action="{!insertRow}"/>
            </apex:facet>
            <apex:column headerValue="Name">
                <apex:inputField value="{!int.Name}"/>                                      
            </apex:column>
            <apex:column headerValue="Age">
            <apex:inputField value="{!int.Age__c}"/>
            </apex:column>
             <apex:column headerValue="Delete">
            <apex:commandLink style="font-size:15px; font-weight:bold; text-align:center;color:red;" value="X" action="{!delRow}">
                <apex:param value="{!rowNum}" name="index"/>
                </apex:commandLink>
                <apex:variable var="rowNum" value="{!rowNum+1}"/>
            </apex:column>
        </apex:PageBlockTable>
    <apex:pageBlockButtons >
        <apex:commandButton value="Save" action="{!insertChild}"/>
        </apex:pageBlockButtons>
    </apex:pageBlock>

  </apex:form>
</apex:page>

I've created the button and I can see the Visualforce page, but when I got to save the records, I get the following error:

Insert failed. First exception on row 0; first error: REQUIRED_FIELD_MISSING, Required fields are missing: [Parent]: [Parent]
Error is in expression '{!insertChild}' in component in page addchildrenvfpage: Class.AddingChildController.insertChild: line 14, column 1

Any suggestions on how to fix this?

*NEW VERSION**

 public class AddingChildController {
 Id parentId;
 public List<Child__c> childList {get;set;}
 public Integer rowNum{get;set;}

public AddingChildController(){
Id parentId = ApexPages.currentPage().getParameters().get('parentId');
childList = new List<Child__c>();
childList.add(new Child__c(Parent__c = parentId));
   }

public void insertChild(){
    insert childList;
   }

public void insertRow(){
   childList.add(new Child__c(Parent__c = parentId));
    }

public void delRow(){
rowNum = 
Integer.valueof(apexpages.currentpage().getparameters().get('index'));
    childList.remove(rowNum);
    }
   }

Best Answer

It looks like your objects are in a master-detail relationship, so the child cannot be created without a parent. In your constructor, as you create your child objects, you're not populating that parent lookup:

public AddingChildController(){
    Id childId = ApexPages.currentPage().getParameters().get('childId');
    childList = new List<Child__c>();
    childList.add(new Child__c());
}

There should be a line in here like

    childList.add(new Child__c(Parent__c = parentId));

In order to do that, you have to have the parent's Id. If your page is designed to take the Id of the parent object in the childId URL parameter, you'd use that value.

A similar change would need to be made to insertRow().

Working Minimal Example

I used the Account and Contact sObjects as an example and stripped this down to the essential functionality. I'm able to insert new child records with this page and controller.

Visualforce Page

<apex:page controller="TestQ232413Controller" >
    <apex:form >
        <apex:pageBlock >
            <apex:PageBlockTable value="{!childList}" var="int">
                <apex:facet name="footer">
                    <apex:commandLink value="Add" action="{!insertRow}"/>
                </apex:facet>
                <apex:column headerValue="FN">
                    <apex:inputField value="{!int.FirstName}"/>                                      
                </apex:column>
                <apex:column headerValue="LN">
                    <apex:inputField value="{!int.LastName}"/>                                      
                </apex:column>
            </apex:PageBlockTable>
            <apex:pageBlockButtons >
                <apex:commandButton value="Save" action="{!insertChild}"/>
            </apex:pageBlockButtons>
        </apex:pageBlock>

    </apex:form>
</apex:page>

Controller

public class TestQ232413Controller {
    Id parentId;
    public List<Contact> childList {get;set;}

    public TestQ232413Controller(){
        Id parentId = ApexPages.currentPage().getParameters().get('parentId');
        childList = new List<Contact>();
        childList.add(new Contact(AccountId = parentId));
    }

    public void insertChild(){
        insert childList;
    }

    public void insertRow(){
        childList.add(new Contact(AccountId = parentId));
    }
}

List Button on Contact

Content Source: URL, /apex/TestQ232413?parentId={!Account.Id}

Related Solutions

[SalesForce] Create new parent record with multiple child record

I think there are many issues in your code. First, as the standard controller is the Purchase Request, why don't you assign its id to the Quote when you create it?

Also, the way you're linking the Quote Line items to the Quote is wrong. What you can do is create a method to:

Create the Quote
Create the Quote Line items
Insert the Quote
Loop on the Quote Line items and assign the Quote id to the lookup field
Insert the Quote Line items

Use try/catch blocks and Database savepoint to rollback in case some records were not inserted correctly.

There are ways to insert the Quote and the Line items at the same time using external ids.

[SalesForce] How to create the child record from Parent Object VF page.

With a standard controller you can only work with the main object, here we have accounts for instance.

For any additional functionality you can extend with a standard controller an extensions.

Some reference:

You'll have to work with an extension controller. In your Visualforce page, add the extension tag to your page definition

<apex:page standardController="Account" extensions="myControllerExtension" />

In this extension controller you'll have something like this :

public class myControllerExtension () {
 public Account myAccount {get; set;}

     public myControllerExtension (ApexPages.StandardController controller) {
      // Get the current Account id 
      id=(Account)stdController.getRecord().id;
      myAccount = [SELECT Id, Name.... FROM Account WHERE id = :id];
    }

     public PageReference Save() {
      // do some stuff with your account...    
      try {
       myAccount.Name = 'Update Name';
       update myAccount;

      } catch (DMLException e) {
        System.debug('Exception occured : ' + e.getMessage());
      }
      // Create a new contact and link it to the account
      try {
       Contact myNewContact = new Contact();
       myNewContact.AccountId = myAccount.Id;
       myNewContact.LastName = 'Doe';
       Insert myNewContact;
     } catch (DMLException e) {
       System.debug('Exception occured : ' + e.getMessage());
     }
    }
 return null;
}

I hope it will help you :)

Have a good day !