Working with Fields

After you create a table, you need to identify and create fields to store data in the table.

In This Section

Field Creation

Introduces fields and considerations for creating them.

How to: Add Fields to Tables

Describes how to add new fields to tables.

How to: Name Fields

Describes how to specify names for fields.

How to: Choose Data Types

Describes how to specify data types for fields.

How to: Add Indexes to Fields

Describes how to specify indexes for fields.

How to: Permit Null Values in Fields

Describes how to specify that fields can accept null values.

How to: Create Default Field Values

Describes how to specify default values for fields.

How to: Specify Input Masks for Fields

Describes how to specify input formats for entering and storing values uniformly in fields.

How to: Format Output for Fields

Describes how to specify the format for field output.

How to: Specify Captions for Fields

Describes how to change the column header text for fields in browse windows and grids.

How to: Set Default Classes for Fields

Describes how to set the default class to use when creating objects or controls by adding fields to forms.

How to: Set Autoincrementing Field Values

Describes how to set field values to increment automatically.

How to: Add Comments to Fields

Describes how to add descriptions for fields.

How to: Restrict Access to Fields

Describes how to display only certain fields in browse windows.

How to: Delete Fields

Describes how to delete fields from tables.

Preventing Duplicate Values in Fields

Discusses preventing duplicate values in fields.

Autoincrementing Field Values in Tables

Discusss considerations for incrementing field values automatically.

Related Sections

Working with Tables (Visual FoxPro)

Introduces creating and working with tables.

Working with Data

Provides an overview and information about using data in your applications, for example, analyzing data requirements and designing your application components to meet those requirements.


© , 1996-2020 • Updated: 11/10/20
Comment or report problem with topic