Chapter 3. Defining and Working with Fields and Tables

In this chapter

Working Under the Hood

Working with Tables

Working with Fields

Working with Field Types

Working with Field Options

Troubleshooting

FileMaker Extra: Indexing in FileMaker

Working Under the Hood

Fields and tables are the heart of any database. By storing information in properly categorized fields within well-organized tables, you impart both function and meaning to what would otherwise be an incomprehensible pile of raw data.

We’ll spend much of this chapter describing what kinds of fields exist in FileMaker Pro, how they store information, and how to ensure proper data integrity in your database solutions. We’ll also discuss naming conventions for fields and tables—techniques ...

Get Special Edition Using FileMaker 9 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.