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.