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.