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:
- Position the pointer on the
appropriate 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 that is referenced
in the Access Definition, click the down arrow and select a table
name from the list.