May 21

Adding Parent and Child Records in a Single Transaction

This topic describes how to add a Parent and Child records in a single transaction, where a Parent is the master record, and the Child is the extension or the details of the master record. For example, assume that a Pizza is a Parent entity, the Types of Pizzas are the Child entity type.  When you enter the Parent record, you want to add the child records at the same time, too. To do this, follow the step by step instructions as below. Also, achieve this topic’s agenda of:

  • Adding parent/child or master-details’ records in a single action.
  • Using database CURD and a Model variable.
  • Using a form inside a form.

Database Configuration

Navigate to the Databases section and create your own database. For more information, see Working with Databases.

  • Step-1: In the database designer, add a one-to-many relation for the parent and child tables.
  • Step-2: Enable the Cascade Option for the one-to-many relation as shown in the image below. For more information, see Working with Database Schema.

Page Design

  • Step-3: On a page, drag and drop a Live Form and bind it to the Parent entity. The Live Form is the Parent form.
  • Step-4: Drag and drop a Design Dialog on the Parent form. The Design Dialog is the base for the Child form.
  • Step-5: Drag and drop a Button widget on the Parent form (created in step-3) and name the button as “Add Child Items”.
  • Step-6: Go to the Events tab of the Add Child Items button, and set the On Click property to open to the Dialogue Design (of step-4).

Model Variable Settings

  • Step-7: Create a Model Variable of the type Child entity and set the flag to the isList option.
  • Step-8: In the Design Dialog, drag and drop a Form widget and bind it to the Model Variable (from step-7).

Note: To add multiple Child objects in the Model Variable, push the data into the Model Variable. To achieve this, select the Child form (from the Design Dialog) and navigate to the Events tab and choose Javascript for the On Before Submit event and add the below-specified code snippet:

Setting Event Properties

  • Step-9: For the Parent form (Live form), navigate to the Events tab and select JavaScript as an operation for the onBeforeServiceCall event.
    Add the below-specified code-snippet in the function generated in the Script tab of the respective page:

Note: Ensure that the naming convention is the same as the related Child entity mentioned in its Parent entity. To verify the name, see .java file from the File Explorer.

 
We use cookies to provide you with a better experience. By using our website you agree to the use of cookies as described in our Privacy Policy.