The Table Lookup Filter
For a very long list of field values, such as a large office with thousands of employee names listed as potential authors, you can use the Filter function at the top of the table lookup window to refine and shorten the list presented.
The choices available in the Filter drop-down menu will be the same as the titles on the column headers in the left-hand pane of the table lookup applet.
To filter a table lookup:
-
Select a column name from the Filter drop-down menu.
-
Enter your filter parameters in the By field.
-
Click the Apply button. The list will now contain only items that match your filter criteria.
-
To return to a complete list that has no filters in effect, click the Apply button with no text in the By field.
Notes:
| |
|
|
Note:
Certain table lookups only allow a single field value to be selected at any time. When you attempt to select more than one value, the value you first selected is cleared.
The information displayed by a table lookup is determined by the library currently being accessed. Field values that exist in other libraries (to which the user has access) but that do not exist in the current library will not be displayed in the lookup list.
For example, the document type “Subpoena” may exist in a library using the Legal database, but it is not a valid document type for a library using the Financial database. For this reason, “Subpoena” will not be available in the document type lookup table if the user is currently accessing a library that is using the Financial database. |
| |
Top of page
