Creating Tables

All topic groups 

Supported table types

Using the Table wizard

Using the Table designer

User-interface elements in the Table designer

Resizing columns

Getting around in the Table designer

Adding and inserting fields

Moving fields

Deleting fields

Saving the table structure

Abandoning changes

Restructuring tables (overview)

Important guidelines for restructuring

Changing the structure

Printing the table structure

Creating custom field attributes

Specifying data-entry constraints

Indexing and sorting dBASE tables

Indexing versus sorting

Sorting or exporting rows

Planning indexes

Using indexes in data entry

Using indexes in queries

Using indexes in reports

Using indexes to link multiple tables

dBASE index concepts

Creating a simple index

To select an index for a rowset

Modifying indexes

Deleting indexes

Indexing on a subset of rows for dBASE tables

Hiding duplicate values

Creating complex indexes for dBASE tables

Rules for dBASE complex indexes

Creating the dBASE complex index

Primary and secondary indexes

Creating primary indexes

Creating secondary indexes

Referential integrity (overview)

Defining referential integrity

Changing or deleting referential integrity