Limiting the retrieved data

After you run a form, you can specify criteria that limit the rows of data and cause a re-retrieval of rows.

StepsTo specify criteria to limit the data:

  1. Do one of the following:

    • Click the Criteria button in the toolbar.

    • Select Rows>Specify Criteria from the menu bar.

    InfoMaker clears all the data.

  2. Specify the criteria.

    In master/detail forms, you specify the criteria in the form’s master area, which is a freeform area for master/detail one-to-many forms and a grid area for master/detail many-to-one forms. Both are like the grid you use when defining data using the Quick Select data source.

    Use expressions and operators in the blank spaces of the grid to specify criteria.

    To specify a second set of criteria in a master/detail one-to-many form, press Page Down to get a new entry form and specify the criteria in the new master area. The second set of criteria will be ORed with the first set; data is retrieved if one set or the other set is true.

    For information about expressions, see “Using Quick Select”, and Chapter 23, “Operators and Expressions.”

  3. Do one of the following:

    InfoMaker retrieves rows based on the criteria.

  4. If you want to modify the criteria, repeat steps 1 through 3.