Master detail form field

In the form design page, users can drag the "Master detail" in the left panel and drop it into the center panel. It will allow users to link a form field with another form in the grid format. Currently the following two types of inner tables are supported:

• Master detail: the accessed child data are controlled by the permission of the child form.
• Multiple master detail: support a list of master detail form.

Master detail table

Creates a special type of parent-child relationship between the object (the child, or "detail") and another object (the parent, or "master"). Access is controlled by the child object or the child form.

The following setup can be set for the master detail form field.

• If checked, export Excel file will show child summary result if any.
• If checked, the data access will be decided by the child form.
• If checked, the child form will be initialized with the setup value (if empty).
• If checked, save child form import information into the selected [Long text] field, notice that do this only when the field value is empty.

Inner table / Grid

The following parameters can be set for the inner table.

• Data input format: Input only; Select only
• Display format: Open as a new tab; Expand in the main form
• Inner form fields: can be print or visible
• Formula options: None; Sum; Count; Average; Summary

See the following image for the inner table example.