Special Edition Using FileMaker 8 - page 1
- Special Edition Using FileMaker 8
- Special Edition Using FileMaker 8
- Table of Contents
- Copyright
- About the Authors
- Acknowledgments
- We Want to Hear from You
- Reader Services
- Introduction
- Best of Three Worlds
- How This Book Is Organized
- Who Should Use This Book
- Part I: Getting Started with FileMaker 8
- Chapter 1. FileMaker Overview
- FileMaker and Its Marketplace
- Introduction to Database Software
- Overview of the FileMaker 8 Product Line
- FileMaker Deployment Options
- What s New in FileMaker Pro 8
- Chapter 2. Using FileMaker Pro
- Getting Started
- Working in FileMaker Pro
- Troubleshooting
- FileMaker Extra: Becoming a FileMaker Pro Power User
- Chapter 3. Defining and Working with Fields
- Working Under the Hood
- Working with Fields
- Working with Field Types
- Assigning Field Options
- Troubleshooting
- FileMaker Extra: Indexing in FileMaker
- Chapter 4. Working with Layouts
- What s a Layout?
- Creating and Managing Layouts
- Working with Parts
- Working with Objects on a Layout
- Working with the Tab Control Object
- Working with Fields
- Portals
- Troubleshooting
- FileMaker Extra: Designing Cross-PlatformFriendly Layouts
- Part II: Developing Solutions with FileMaker
- Chapter 5. Relational Database Design
- Understanding Database Design
- Database Analysis
- Working with Entities and Attributes
- Understanding Relationships
- Relationship Optionality
- Understanding the Role of Keys in Database Design
- Many-to-Many Relationships: Solving the Puzzle
- The Basics of Process Analysis
- FileMaker Extra: Complex Many-to-Many Relationships
- Chapter 6. Working with Multiple Tables
- Multitable Systems in FileMaker Pro
- Creating a One-to-Many Relationship in FileMaker
- Working with Keys and Match Fields
- Understanding Table Context
- Working with Related Data
- Creating a Many-to-Many Relationship
- Relational Integrity
- Rapid Multitable Development
- Troubleshooting
- FileMaker Extra: Building a Three-Way Join
- Chapter 7. Working with Relationships
- Relationships Graphs and ERDs
- Relationships as Queries
- Creating Self-Relationships
- Creating Ranged Relationships
- Creating Cross-Product Relationships
- Working with Data from Distant Tables
- Working with Multiple Files
- How and When to Use Multiple Files
- Troubleshooting
- FileMaker Extra: Managing the Relationships Graph
- Chapter 8. Getting Started with Calculations
- Understanding How and Where Calculations Are Used
- Exploring the Calculation Dialog Box
- Essential Functions
- Using Conditional Functions
- Aggregate Functions
