3. Defining and Working with Fields and Tables

Working Under the Hood

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

This chapter describes what kinds of fields exist in FileMaker, how they store information, and how to ensure proper data integrity in your database solutions. You will also find naming conventions for fields and tables—techniques that you can use to make your FileMaker databases meaningful to yourself and others for the long period of time that they may be in use.

If you’re new to development in FileMaker Pro, this chapter is a good place to start. ...

Get FileMaker® 12 In Depth 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.