Narrowing a List by an Index

An index is one of the columns in the table. You can narrow a list by information stored in one of the columns or indexes. The List Search window lists these indexes. Because the columns vary in each table, the indexes that appear in the List Search window vary for each table you have open. (For example, you could limit a list of borrowers by location.)

To narrow a list by an index

1 Open the view to list the rows.

For instructions on displaying the list window, see Opening a View in the Table Editor .

2 Press CTRL+F2 to open the List Search window.
3 Choose an index you want to limit the list by.
4 In the Search for field, enter the value stored in that index for which you want to list all rows that contain that value.

For example, if you were limiting the collection table to list only those rows or records that have 10 as the number of items in a certain collection, you choose the No. of Items index in the List Search window for the List Collection window and enter “10” in the Search for field. The List Collection window displays only those collections that have 10 items.

5 Click OK.

Horizon displays those rows that match the limit.

When you are limiting by a code, such as BTYPE, location, collection, and so forth, you must enter the exact code. (For instructions, see Using an Entry Aid.) When you are limiting by free text, such as borrower name or BTYPE description, you should precede and follow the text in the Search for field with an asterisk. (For more information, see Narrowing a Search Using Truncation .)

 


© 1998-2017 Sirsi Corporation