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:
- 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 values in one or more specified columns.
To add table specifications to an Access Definition:
- Position the pointer on the
desired table name in the Table/View grid in the Access
Definition Editor.
- Right-click to open the shortcut menu.
- Select a choice for Table Specifications from
the shortcut menu. The choices correspond to the tabs on the Table
Specifications dialog.
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.