FileMaker 8 was built to work with related data and make it seem easy. Related fields, for example, work just like ordinary fields. Not only can you put them on layouts, but you can use them in Find mode and the Sort dialog box too. When you do, it just works exactly the way you'd expect.
Now you're ready to learn how to take advantage of FileMaker's relational capabilities to make the best database system possible. You can make data entry a breeze, minimize double-entry, show data from different tables side by side, and easily move from one kind of data to another. You can also give each relationship you create special powers given it to make creating, deleting, and displaying related records easier. This chapter shows you how to do all these things.
Part I: Introduction to FileMaker Pro
Your First Database
Organizing and Editing Records
Building a New Database
Part II: Layout Basics
Layout Basics
Creating Layouts
Advanced Layouts and Reports
Part III: Multiple Tables and Relationships
Multiple Tables and Relationships
Advanced Relationship Techniques
Part IV: Calculations
Introduction to Calculations
Calculations and Data Types
Advanced Calculations
Extending Calculations
Part V: Scripting
Scripting Basics
Script Steps
Advanced Scripting
Part VI: Security and Integration
Security
Exporting and Importing
Sharing Your Database
Developer Utilities
Part VII: Appendixes
Appendix A. Getting Help