Switch to: V10V9V8V7V6V5

Form Editor - Sub Form Help

The Sub Form control provides the ability to display data related to the data shown in a main form. This relation may be built based on the database links (Foreign Key, Object Ptr, Binary Link) or defined by the user using the map of fields or the map of properties.

Form Editor - SubForm

Properties

Form Editor - Sub Form Properties

  • Data Mode – Defines how the control value change is applied to the field:
    • Inherited – The mode is inherited from the parent form
    • Add – The values are intended for a new record
    • Edit – The values are assigned to the fields, but not committed
    • Edit And Commit – The values are assigned to the fields and committed
    • ReadOnly – The values can't be changed
  • Link – The name of the link. If it is set the subform shows related records from the linked table.
  • Map Fields – The map of the fields, it defines the correspondence between the fields of the form and the subform. If it is set the form shows only those records for which the values of the mapped fields are equal in the form and in the subform.
  • Map Parameters – The map of the parameters, it defines the correspondence between the fields of the main form and the parameters of the query used in the subform. If it is set the subform shows only the records returned for its query where the parameters are replaced with the values of the mapped fields from the form.
  • Name – The name of the control.
  • Source – The source of the records – it may be the table, view or a query.
  • Sorting – Defines the sorting of records in the subform.

Widget

  • Auto Fill Background – This property holds whether the control background is filled automatically.
  • Enabled – Defines whether the control is enabled or not.
  • Font – This property holds the font currently set for the control. The default depends on the system environment.
  • Palette – This property describes the control's palette.

The palette is used by the control's style when rendering. The color roles from this palette are combined with the control's default palette to form the control's final palette. The default depends on the system environment and may be different on different platforms. Control propagates explicit palette roles from parent to child. If you assign a brush or color to a specific role on a palette, that role will propagate to all the control's children, overriding any system defaults for that role.

  • Tooltip – The tooltip text.

Layout Item

  • Alignment – Defines both the horizontal and vertical alignment.
  • Expand Horizontal – If ON the control is expanded horizontally.
  • Expand Vertical – If ON the control is expanded vertically.

Size

  • Width – The width of the control.
  • Height – The height of the control.

Signals

Form Editor - SubForm Signals

QWidget

  • customMenuRequested – This signal is emitted when the user has requested a context menu on the control.
  • windowIconChanged – This signal is emitted when the window's icon has changed.
  • windowTitleChanged( title ) – This signal is emitted when the window's title has changed, with the new title as an argument.

QObject

  • created – This signal is emitted after the object is created.
  • destroyed – This signal is emitted immediately before the object is destroyed, and can not be blocked. All the objects's children are destroyed immediately after this signal is emitted.
  • needUpdate – This signal is emitted when the control needs to be updated, for example, on the change of the current record.
  • objectNameChanged( objectName ) – This signal is emitted after the object's name has been changed, with the new object name passed as an argument.