Description of the Table Wizard

ID: Q114290

The information in this article applies to:

• Microsoft FoxPro for Windows, version 2.6
• Microsoft FoxPro for MS-DOS, version 2.6

SUMMARY

The information below describes the Table Wizard and explains how to create a table.

This information is also found in FoxPro online Help in the "Table Wizard" topic.

MORE INFORMATION

The Table Wizard helps you set up a new Microsoft FoxPro table. Just choose the fields you want for your table from the sample tables provided. These samples are already set up with typical data types and field lengths: You can use them as they are, or rename them and change the data types and field lengths as needed.

Table Wizard Steps

Step 1 of 3: Selecting Fields to Include in Your Table

First, select a sample table from the Tables list. The fields in the sample table are shown in the Fields list; select the fields you want to use in your table. Use the arrow buttons to add or remove fields in the Selected Fields list. You can combine fields from several different tables if necessary.

When you select a field, the status bar at the bottom of the screen shows the field's data type and length. For example:

   Last Name:  [C(50)]

Step 2 of 3: Setting the Sort Order

Select up to three fields from the Available Fields list to set the sort order for the records in your new table. The selected fields are combined to create an index tag for the table.

For example, if you choose State and then City, the records in your table will be sorted by state, and then by city within each state.

Choose the Ascending option to sort records from the beginning of the alphabet, the lowest number, or the earliest date; choose the Descending option to sort records from the end of the alphabet, the highest number, or the latest date.

Step 3 of 3: Saving, Browsing, or Modifying Your Table

Select one of the four options and choose the Finish button:

• Save Table displays the Save As dialog so you can give the table a name and save it as a .DBF file.
• Save And Browse For Data Entry saves the table and displays it in a Browse window so you can view, enter, and edit records.
• Save And Create An AutoScreen For Data Entry saves the table and automatically creates a wizard-generated data-entry screen so you can view, enter, and edit records.
• Modify Structure Of Table displays the Save As dialog so you can give the table a name, then displays the Table Structure dialog, where you can modify the table as needed.

Last Reviewed: June 27, 1995