Table wizard, step one

Build a new table structure by selecting fields previously defined for other tables:

1. Choose a sample table structure from the Tables list. The wizard displays the fields from the selected table in the Available Fields list.

2. Choose a field you want to add to your new table structure. When you select a field, its type and width are displayed below the field list. Double-click the field or use the arrow buttons to add the selected field to the Selected list. To add all the fields in the sample table structure to your new table structure, click the >> button.

3. To add fields from more than one sample table to build the new table, select another table when you're finished with the first one. The fields you have already chosen remain in the Selected Fields list and you can add to them.

4. To rearrange the order of fields in the Selected Fields list, drag them up or down.

5. When you are satisfied with the fields and their order in the Selected Fields list, click Next.

Note: Your new table cannot have more than one field with the same name.

Dialog box options

Tables

Choose a sample table structure. The selected table’s pre-defined fields then appear in the Available Fields list.

Available fields

Choose one or several or all of the fields to be used in your new table structure. Double-click each field in the order you want it to appear in your new table. Or click the >> button to choose all the fields in the sample table structure.

Selected fields

Displays the fields you selected in the Available Fields list, and in the order you selected them.

Type

The field type (such as character, numeric, logical, and so on) of the field selected in the above list.

Width

The width of the field selected in the above list.

Arrows

Click the > arrow to add the selected field in the Available Fields list to the bottom of the list of fields in the Selected Fields list.. Click the >> arrow to move all the available fields to the Selected Fields list..

Click the < arrow to remove the selected field from the Selected Fields list to the bottom of the Available Fields list Click the << arrow to remove all the selected fields from the Selected Fields list to the bottom of the Available Fields list.