How You Access the Condition Builder

The ProMatrix Condition Builder allows you to build a set of logical field conditions to be used to select records for a form or report. The way the conditions are used depends on how you access the Condition Builder, as follows:

       Toolbar Locate: When you click the Form Toolbar Locate control, VPM Enterprise displays the Condition Builder. After you build a condition and click OK, the condition you build is used to locate records that match the condition. If more than one record matches the condition, all matching records are displayed in a List grid. If you select a record in the List grid, the selected record becomes the current record on the form.

       Toolbar Filter: When you click the Form Toolbar Filter control, VPM Enterprise displays the Condition Builder. After you build a condition and click OK, the condition you build is used to apply a filter to the records displayed on the form. While the filter is in effect, only records that match the condition are displayed on the form.

       Toolbar Group Delete: When you click the Form Toolbar Group Delete control, VPM Enterprise displays the Condition Builder. After you build a condition and click OK, the condition you build is used to select the group of records to be deleted. Only records that match the condition are deleted.

       Report Setup For Option: When you click the For check box on the Report Setup dialog, VPM Enterprise displays the Condition Builder. After you build a condition and click OK, the condition you build is used to select the records displayed in the report. Only records that match the condition are displayed in the report.

       Report Setup While Option: When you click the While check box on the Report Setup dialog, VPM Enterprise displays the Condition Builder. After you build a condition and click OK, the condition you build is used to select the records displayed in the report. Records that match the condition are displayed in the report until the first non-matching record is found. When the first non-matching record is found, the report terminates. If the first record is non-matching, no records are displayed in the report.

More:

How You Use the Condition Builder