1. SuiteCloud Platform
  2. Customization
  3. Custom Records Overview
  4. Parent-Child Record Relationships
  5. Creating a Parent-Child Relationship

Creating a Parent-Child Relationship

The following example shows how to create a custom field that associates related records and displays child records on a parent record. This example creates an entity custom field named Customer Records to associate customer records with case records. In this example, Case is the parent record and Customer is the child record. The Customer Records field displays a list of customers associated with the case.

To create the parent-child relationship:

  1. Go to Customization > Lists, Records, & Fields [Custom Field] > New, where [Custom Field] is the required field type.

    The type of field you select depends on the type of record you want to associate.

  2. In the Label field, enter a name for your custom field. For this example, enter Customer Records.

  3. In the Type field, select List/Record or Multiple Select.

    To associate multiple records to another record, select Multiple Select. In our example, Multiple Select lets you associate multiple customer records to a case.

  4. In the List/Record field, select the parent record you want to associate this list (of customer records, in this case) with. For this example, select Case. Note that this field is available only if you selected a type of List/Record or Multiple Select.

  5. To make the Case record a parent of the Customer child record, check the Record is Parent box. With this box checked, a child sublist appears on the parent record. The Record is Parent box is available after you select a valid record type in the List/Record field.

  6. On the Applies To subtab, you specify the child record. Check the box beside the type of child record you want to associate with the parent record previously selected in the List/Record field. If applicable, you can check more than one record type. For this example, check Customer.

  7. Click the Display subtab.

  8. In the Parent Subtab field, select the subtab where you want this list to display on the parent record. Note that this field is available only when Record is Parent is checked.

  9. Click Save.

You'll now have a parent record of Case with a subtab called Customers that lists all customers affected by this case.

Example parent-child relationship sublist
Note:

When associating a list with a transaction, you can select only transactions with forms that can be customized. For example, you can associate a list of cases with a cash sale but not to a bill.

The following transaction types are available as parents:

To watch training videos about creating parent-child relationships, see Parent-Child Record Relationship Training Videos.

For information about triggering user events, see Triggering User Events for Parent-Child Records.

Related Topics

General Notices