New dialog box

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.