Use this dialog box to select the fields from the current object data table to use as key fields in the database table.
- Method area
-
Select the method for setting key fields.
- Reference Existing Fields
-
Use existing fields as key fields.
If you select this option, select the fields to use in the Existing Fields area.
- Generate Key Field
-
Create a new field to use as the key field.
If you select this option, specify a name for the field in the Generate Key area. When the database table is created, this field will contain a unique number for each record.
- Existing Fields area
-
If you select Reference Existing Fields, select the fields to use as key fields.
- To specify a key field, select the field and click On.
- To deselect a key field, select the field and click Off.
- To change the name of a field, select the field, type a new name in the Rename box. Click Rename.
- Generate Key area
-
If you select Generate Key Field, specify a name for the new field. The name must be different from other fields in the table.