Sample Null Query

To identify all locations for your company that have no work centers associated with them, use a query like this:

  1. Open the Locations form.
  2. Press Ctrl+Q.
  3. On the Additional Criteria tab, in the three query criteria fields:
    • From the first list, select WC (for "Work Center").
    • From the operator list, select = (Equals).
    • In the adjacent value field, specify null.
  4. Click Add.
  5. Click Refresh.

    All records that meet the specified criteria are retrieved and displayed in the Results grid.

  6. To return these records to the parent multiview form (Locations), click OK.
  7. When prompted for confirmation, click Yes.
Note:  When you click Yes, the system returns all retrieved records to the parent form, replacing whatever was previously displayed in that form. You cannot pick and choose which records to return.