Share via

Determining the Fields You Need

  • Article

To determine the fields in a table, decide what you need to know about the people, things, or events recorded in the table. You can think of fields as attributes of the table. Each record (or row) in the table contains the same set of fields or attributes. For example, an address field in a customer table contains customers' addresses. Each record in the table contains data about one customer, and the address field contains the address for that customer.

In This Section

  • Identifying Fields
    Provides tips for determining the fields you might need in your database.

  • Using Primary Key Fields
    Explains how each table in your database should include a field or set of fields that uniquely identifies each individual record stored in the table, for Visual FoxPro to work most efficiently.

  • Designing Databases
    Take advantage of relational database technology in Visual FoxPro with well-planned databases.

  • Working with Tables
    Describes how to make sure your tables have the structure that your application requires. Data type and index choices are essential to the success of your application.

  • Working with Fields
    Introduces creating and working with fields in tables.