ODBC data source
Shows the data source you selected in the Link to Database dialog box.
Table name
The name of the new table you are defining.
Field definitions
Name
The name of a field you are adding to the new table.
Type
The data type for the field specified in the Name text box. The available data types depend on the database driver associated with the database to which you are linking.
Length
The size in bytes of a variable-length field.
Decimal
The number of decimal places supported by the field. This applies only to numeric fields that are not integers.
Primary key
Identifies whether the field specified in the Name text box is part of the primary key (a field or fields that uniquely identify each record) for the database table.
Unique
Identifies whether the field specified in the Name text box cannot contain duplicate values.
Required
Identifies whether the field specified in the Name text box cannot contain a null value.
Fields
Lists the fields in the new table you are defining.
Add
Adds the field specified in the Name text box to the table you are defining.
Delete
Removes the selected field from the table you are defining.
