CRMJettyBack to crmjetty.comContact us
Menu
Docs / Guides

CRMJetty Portal

Works with
Docs / Dynamics 365

Dynamics 365 Customer Portalv6.3.0

Docs / Salesforce

Salesforce Customer Portalv6.3.0

Docs / Business Central

Business Central Portal

Guides / Forms

How to Link Parent and Child Records in a Form

4 min readUpdated
Short answerOpen an Add form in Design → Form Builder, turn on the Parent-Child Link toggle, select the Child Entity, Relationship Type and the field to Create Unique Records On, drag the child fields onto the form and publish it. The link works only on Add forms.

A parent-child link combines the fields of two related entities in one form. When a portal user submits the form, the portal creates the parent record and the linked child record in your CRM. For example, one form can create a customer order and its order items.

Before you start

Steps

  1. Go to Design → Form Builder.
  2. Open an Add form for the parent entity, or create one. See How to Create a Portal Form for Any CRM Entity.
  3. In the form configuration, turn on the Parent-Child Link toggle.
  4. In Child Entity, select the entity that acts as the child.
  5. In Relationship Type, select the relationship that connects the parent and the child.
  6. In Create Unique Records On, select the parent field that identifies unique records.
  7. Drag the child entity fields you need from the field list onto the form layout.
  8. Select Save, then publish the form.
Form Builder Add form configuration with the Parent-Child Link toggle on and Child Entity, Relationship Type and Create Unique Records On filled in

Parent-child settings

Setting What it does
Child Entity The entity that acts as the child in the relationship.
Relationship Type The relationship that defines how the parent and child entities are connected.
Create Unique Records On The field the portal uses to make sure each record is unique when it creates the entry in your CRM.
Fields Display Shows the child fields you can add to the form, based on the selected relationship type.

Example: customer orders and order items

You run a customer order portal and want portal users to enter an order and its items in one form.

  1. Open the Add form for the Customer Order entity.
  2. Turn on the parent-child link.
  3. In Child Entity, select Order Items.
  4. In Relationship Type, select Order (Customerid). Each customer order can have several order items.
  5. In Create Unique Records On, select Order ID, so each order record is unique.
  6. Drag the child fields Item Name, Quantity and Price onto the form.
  7. Publish the form.
Portal Add form showing customer order fields followed by Item Name, Quantity and Price fields from the Order Items child entity
Portal Add form showing customer order fields followed by Item Name, Quantity and Price fields from the Order Items child entity

Tip: To send the submitter a confirmation email from a parent-child form, the email template can use fields of both entities. See How to Send Confirmation Emails After Form Submission.

Use When you want portal users to
Parent-child link Create a parent record and its child record together in one Add form.
Sub-grid See and manage the existing related records of a record they are editing or viewing. See How to Add Sub-Grids to Portal Forms.

Troubleshooting

The parent-child option is missing: Check the form type. The link is available only on Add forms, not on Edit or Detail forms.

No child fields appear: Select a Relationship Type first. The child fields shown depend on the relationship you select.

The child entity is not in the list: Enable it in the portal and sync it. The Form Builder shows only entities synced with the portal.

Did this solve it?No, contact support