Table Specifications

Table specifications provide display and criteria parameters for data. Display parameters apply when you edit or browse data, and when you select rows for a Point and Shoot list. Criteria apply when you select rows for display, or archiving, extracting, or restoring data.

You can do the following tasks:

  • Include or exclude table columns from a data display.
  • Display or select specific data by assigning selection criteria.
  • Create SQL WHERE clauses to define complex selection criteria.
  • Arrange displayed rows in ascending or descending order according to the values in one or more specified columns.

Add table specifications to an Access Definition

Do the following to add table specifications to an Access Definition:

  1. Position the pointer on the appropriate table name in the Table/View grid in the Access Definition Editor.
  2. Right-click to open the shortcut menu.
  3. Select a choice for Table Specifications from the shortcut menu. The choices correspond to the tabs on the Table Specifications dialog.
    Example of the Columns tab on the Table Specifications dialog that shows column names, data types, and other details.
Initially, the Table box shows the name of the table you selected on the Access Definition Editor table list. To edit table specifications for another table that is referenced in the Access Definition, click the down arrow and select a table name from the list.