Master/detail form

View video

This option allows you to create forms to update, on a single screen, tables with 1:N relationship.

New detail

In the application menu, you can create a new connection by clicking on the “New detail” option from Master/detail folder.

Creating a new detail.

Include name

Interface to set the Name and Label of the link. It will be displayed in the master application as a field. The name cannot contain spaces in lower special characters.

By checking the option Create a new block to place this field, the application will position itself in the new block automatically.

Interface to set link name and label.

Application list

Only the form types: Editable Grid or Editable Grid View can be used as an application detail. You must create the form detail application before you create the Master/Detail link, because you will need to select the application during the link creation.

Interface to configure the detail application.

Foreign Keys

This step is enabled when you create the master/detail between form type applications. Here will be set the foreign key that links the two tables in the database.

In the left column the all fields of the master application are listed and in the select field, on the right, the list of all fields of the selected application to the Detail.

The developer must bind the fields that are foreign key in the master table. The other fields must remain blank.

Interface to configure the detail application.

Parameters definition

In this step, the global variables defined in the detailed application for parameter passing will be listed.

For masters/details created with grid applications, defining a parameter is essential to display data in the detail related to the master being displayed.

Without this parameter, all the data from the grid used in the detail will be displayed.

Click here to access the documentation related to creating parameters in the grid.

Interface to configure the link parameters.

In the Types of Parameters we have three options, they are:

Fields

This option the connection will use the destination application field to make the record call according to the query application field.

Fixed value

This option allows the user to define a fixed value that will be used for the next application call.

The use of variables is not allowed.

No value

This option allows you to create the connection without the need to send any parameters to the next application.

General Settings

After the link creation, you can change some settings by clicking on the link and selecting the properties option.

Label

Define the name shown in the application. This attribute accept text or language variable.

Label below field

Define the text that will be shown below the detail. This Attributo to accept text or language variable.

Grid Property

• Initial Mode - Defines whether the detail application will be initiated by the search module or the grid module.
• View only -
• Number of Lines - Defines the number of lines that the application will show at the beginning.
• Number of Columns - Defines the number of columns that the application will show at the beginning.
• Display Header - Defines whether the application header will be displayed.
• Active Navigation Buttons - Defines whether the application Navigation Buttons will be displayed.

This configuration block is only displayed in master detail between a grid and a form.

Form properties

Within this option you can select the buttons that are going to be displayed in the detail form.

• Enable insert button on target application
• Enable update button on target application
• Enable delete button on target application
• Enable navigation button on target application
• Maintain the WHERE clause in the target application

This configuration block is only displayed in master detail between two forms

Iframe properties

This option allows you to configure the iframe height and width (in pixels) where the detail form is going to be displayed.

• Iframe width - Sets the width of the iframe
• Iframe height - Sets the height of the iframe
• Remove application margin - Remove the application margin inside the iframe
• Remove application border - Remove application borders inside the iframe

Detail properties

• Form Type - The option “Form Type” only works to change applications already configured with horizontal orientation, used within the detail. E.g. Multiple Rows or Editable Grid. This attribute is only displayed in links between two forms.
• Paging : Allows you to select your form detail paging. The options are:
  • Partial : This option will set page layout as partial, with a limited records per page, according to the quantity informed within the option below “Lines per page”
  • Total : This option will set the page to display all records in one page.
• Lines per page : Here you can set the amount of records that are displayed in the detail form, you will need to set that just if paging is partial.This attribute is only displayed in links between two forms.
• When deleting : This option allows you to choose how the form detail dependencies will be treated in a deletion. This attribute is only displayed in links between two forms. The options are:
  • Warn when there are dependencies : Displays an error message if there is dependency on the detail form record that is being deleted from the master form.
• Delete dependencies without warning : Deletes all existing dependencies in the detail form without warning the user.