Usually, you use a form to view the data in a table, but you can also view the data directly by running the table from Object Designer.

To view table data without using a form

  1. Open Object Designer and select the table to view.

  2. Click Run.

    The table data is displayed in a tabular format.

Changing Table Sort Order

Table data is displayed in the sort order defined by the current key. If more than one key is defined for the table, you can switch between keys to change the sort order.

To view table data with a different sort order

  1. Open Object Designer and select the table to view.

  2. Click Run.

  3. From the View menu, click Sort.

    The Object - Sort window appears.

  4. Under Key, click the key that defines the sort order that you want to use.

  5. Under Order, click Ascending or Descending to control the record display order.

  6. Click OK or Apply to apply the new key.

    If you click OK, the Sort dialog box closes. If you click Apply, the Sort dialog box remains open. Using Apply is convenient if you frequently change the sort order.

See Also