Table Specifications

Table specifications provide display and criteria parameters for data. Display parameters apply when editing or browsing data, and when selecting rows for a Point and Shoot list. Criteria apply when selecting rows for display, or archiving, extracting, or restoring data.

You can:

To add table specifications to an Access Definition:

  1. Position the pointer on the desired 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.
    table specifications columns tab showing column names, data types and other details, explained below
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 referenced in the Access Definition, click the down arrow and select a table name from the list.