Opening a View in the Table Editor

Once the Table Editor is running, you open a view by entering its name in the Code Lookup Horizon View window. Once you know the name of the view, use this method to open any view.

You can access some database tables through views in other processes. (For example, you view data from the borrower table in the Edit Borrower window in Circulation. For a more detailed description of views, see About Introduction to Horizon Views .)

To open a view in the Table Editor

1 Log in to Horizon.
2 Start the Table Editor process.

The default location of this process is the Administration folder on the navigation bar.

Horizon displays the Code Lookup Horizon View window. This window lists all views in the Horizon system:

Note: In general, the name of the view is similar to the name of the table it is a view of. (For example, the collection view is a view of the collection table.) Some views, on the other hand, do not have the same name as the table they are a view of. (For example, the add_fee view is a view of the burb table.)

3 Do one of these options to move the selection arrow to the view name you want:
Enter the first few letters of the view name in the Mq View field.
Enter the view name, including any underscore dashes, in the Mq View field.

Horizon places the selector arrow next to the view name in the list.

4 Click OK.

Horizon displays the list window, overlaid by a search window if the table contains many rows.

For instructions on narrowing a search in a table that has many rows, see Using the List Search Window.

 


© 1998-2017 Sirsi Corporation