After clicking the Look Up button a screen appears that lets you search for a value or values relevant to the field name selected:
At the top of the screen is a search text box that lets you narrow your search for values. To use this text box, perform the following:
Enter your search criteria in the Search text box. As you type, the entries in the list will shorten depending on your search criteria.
Select the desired values and click the button to add them to the Selection list box on the right-hand side of the screen.
At the left-hand side of the screen is a list box containing the first 10 values for the field name selected. To include these values in your search, follow these steps:
Click on an item to select it.
To select more than one item, hold down the CTRL key while selecting each item.
Click the button.
The selected values will appear in the list on the right-hand side of the screen and will be included in the search criteria for your report.
To navigate through the list, use the following buttons:
- Click this button to return to the first page of the table.
- Click this button to display the previous page in the table.
- Click this button to display the next page in the table.
- Click this button to move to the last page in the table.
Enter a page number in the text box to move to that page.
After clicking the Add button, your selections will appear in the list box on the right-hand side of the screen.
Click OK to add the selections to the constraint dialog box
To remove a selection, highlight the value and click the button
To remove more than one selection, hold down the CTRL key while selecting each item and click the button
To remove all selections, click the button