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:
|
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 |