Select a Table to Browse

After you open an Archive File, you can select a table to browse within the Archive File.

You can browse data in any table in an Archive File. To display rows in the CUSTOMERS table, double-click the table name. In the Browse Archive File Table Data dialog, a browse window displays the data. Browse Archive File Table Data dialog

The browse window toolbar lets you select display options and menu choices that pertain to the display. For example, you can display or hide column attribute information, join and unjoin tables to view related data, and switch the display format. Shortcut menu commands, available when you right-click a column heading, allow you to find, include, or exclude rows that contain specific data.

Data is in columnar format (column names are displayed across the top and data is displayed in columns beneath headings) or sidelabel format (column names are on the left and a row of data is displayed to the right of headings). The sidelabel format is useful if you want to view all columns or data in a wide column for a row, without having to scroll the display horizontally. The default format is set in Personal Options; however, you can switch the display format using the Columnar toolbar button Columnar toolbar button and the Sidelabel toolbar button Sidelabel toolbar button.

To determine if Customer 00026 ordered Item DC002, you must first locate the CUSTOMERS row with CUST_ID 00026. Right-click a column heading and click Find from the shortcut menu to display the Find dialog.

Find dialog

Type 00026 in Find what and, on the Columns tab, select CUST_ID. When you click Find Next, the Browse Archive File Table Data dialog is scrolled to the CUSTOMERS row for CUST_ID 00026 and “00026” is highlighted. To determine if this customer ordered Item DC002, you must join to the ORDERS table to browse related Orders rows and, from ORDERS, join ITEMS to browse related Items rows. (Before going on to view the related date, close the Find dialog.)