Specify Form Run Options

For components that support shortcut menus for Find, Add, and Details forms, use this form to set up and maintain specifications for opening the relevant form.

This dialog box is currently used only by the Edit Collection Specifications for Subcollection form.

Field/Option Description
Form Specify the internal name (not the caption) of the form to be run.

When specifying the tile form to use, you have these options:

  • You can use drop-down list to select the tile form to use from the list of available tile forms.
  • You can specify an expression that the form then uses to determine what tile form to use.

    This expression must be defined and entered manually in this field.

    The system reads and interprets the expression at the time that the form is loaded. Once interpreted, the grid's use of the tile form is not affected by changes to the grid's Tile When value, if any exists.

Filter This is the filter to be applied to the form being opened. Specify the filter as a SQL WHERE clause using the FILTER keyword and property names as parameters (instead of column names). You can include substitution keywords.

The entire string, after any substitutions are performed, is passed to the IDO in its Filter property prior to the load collection call.

If the filter is for a subcollection, and there are substitutions for variables included in it, then a dependency is created between the subcollection and the variable. When the variable's value is changed, the subcollection is refreshed.

If the filter is for a list source, and there are substitutions for variables included in it, then a dependency is created between the list source and the variable. When the variable's value is changed, the list source is invalidated.

Distinct To apply the DISTINCT keyword to the primary collection on the form being opened, select this option. Otherwise, clear it.
OrderBy Specify the ORDERBY keyword, which controls the sorting of the primary collection on the form being opened.
GroupBy Specify the GROUPBY keyword for the primary collection on the form being opened.
Set Variables Specify values for variables, components, or properties used in the event handler.
Property This field applies only to opening an Add/Details form. Specify the property in the parent form that is used to filter the child form being opened.
OK/Cancel/Optional This field applies only to opening modal child forms. To eliminate the OK or Cancel prompt when a user closes a modal child form with the Close box, select this option.

To have the prompt display, clear this option.

Popup Window To have the form display in a pop-up window, select this option.

See About pop-up forms.

Reload After Child Saves (RLACS) This field applies only to opening linked child forms.

To refresh the current IDO item in the parent form's collection after the child form's primary collection is saved, select this option. Otherwise, clear the check box.

Use this option in cases in which saving the child form might cause the data in the parent form's current item to be obsolete.

LinkBy This field applies only to opening linked child forms. Specify the Windows client LINKBY keyword.
Set Variable On Link Update This field applies only to opening linked child forms. Specify targets and values for variables