Specifications

Searching the Database 51
ID Works Basic Version 5 Operator’s Guide
Definitions of potential selections in the Field Constraint area are:
Include NULL values — If selected, records with null values in the
field (no information in the database column) will be included in the
search results.
Match text case-insensitive — Access always selects text case-
insensitive. You can ignore this option.
Exclude constraint detail — If selected, all records that do not
match the Constraint value will be included in the search results.
Use this option when it is easier to define records that should not be
included.
In the Constraint Detail area, you may be required to enter
information in Constraint value only, in Constraint value and
Ending constraint value, or in the Multi-value Constraint List area. If
the Production Form field you selected is connected to a date type
database column, the Constraint value and Ending constraint
value have an arrow at the right side of the field. You can click the
arrow to select a date from a calendar or type a date in the field.
Using the Multi-value Constraint List
To select records that match any of a number of criteria (for example,
to select records for employees living in New York, London, or
Amsterdam), select the IN constraint rule. The Insert button in the
Multi-value Constraint List area becomes available. When you click
Insert, the Constraint List dialog box opens. Here you enter
constraint criteria (for example, Amsterdam to select employees living
in Amsterdam). When you click OK, the Constraint List dialog box
closes and the constraint you entered appears in the list of
constraints. You can insert as many constraints as necessary. You
can change or delete constraints in the list by selecting them and then
clicking Edit or Delete.
Access does not support wildcard characters for entries in the Multi-
value Constraint List.
Adding and Clearing Constraints
When you have entered the required constraint detail for the
Production Form field and constraint rule you selected, the Add
Constraint button becomes available. When you click Add