Creating a Database in FileMaker Pro 8.5: Visual QuickProject Guide

Table of contents

1. Copyright
2. Introduction
   1. What You’ll Create
   2. How this Book Works
   3. Visit the Web Site
   4. The Next Step
3. 1. About Databases and FileMaker Pro
   1. Database Features
   2. Flat File Vs. Relational
   3. About FileMaker Pro
   4. Extra Bits
      1. Database Features p. 2
      2. Flat File Vs. Relational p. 5
      3. About FileMaker Pro p. 6
4. 2. Defining the Primary Fields
   1. Make a New Database
   2. About Creating Fields
   3. Create Text Fields
   4. Create Number Fields
   5. Create Date Fields
   6. About Calculations
   7. Create Calculation Fields
   8. About Field Options
   9. Set Auto-Enter Options
   10. Set Validation Options
   11. Set Storage Options
   12. About the Default Layout
   13. Extra Bits
       1. Make a New Database p. 10
       2. Create Text fields p. 12
       3. Create Number fields p. 13
       4. Set Validation Options p. 19
5. 3. Creating the Data Entry Layout
   1. About Layout Tools
   2. Color the Layout Parts
   3. Format Fields and Labels
   4. Clear Some Space
   5. Add a Tab Control
   6. Add a Background Block
   7. Place Fields in the Block
   8. Place the Footer Field
   9. Place the Savings Fields
   10. Place the Stock Fields
   11. Place the CD Fields
   12. Place the Bond Fields
   13. Set Field Formatting
   14. Set Auto-complete Fields
   15. Name and Save the Layout
   16. Extra Bits
       1. About Layout Tools p. 24
       2. Format Fields and Labels p. 27
       3. Add a Tab Control p. 29
       4. Place Fields in the Block p. 32
       5. Place the Savings Fields p. 35
6. 4. Creating the Related Tables
   1. Create the Savings Table
   2. Create the Stocks Table
   3. Create the CD Table
   4. Create the Relationships
   5. Define More Fields
   6. Place the New Fields
   7. Create the Portals
   8. Extra Bits
      1. Create Savings Table p. 48
      2. Create Relationships p. 56
      3. Place the New Fields p. 61
      4. Create the Portals p. 63
7. 5. Making the List Layout
   1. Create a Blank Layout
   2. Format the Layout Parts
   3. Insert the Fields
   4. Add Labels and a Title
   5. Create the View Button
   6. Extra Bits
      1. Create a Blank Layout p. 70
      2. Format Layout Parts p. 71
      3. Create the View Button p. 74
8. 6. Creating Summary Reports
   1. Create More Fields
   2. The Savings Report
   3. The CD Report
   4. The Savings Bond Report
   5. The Stock Report
   6. Extra Bits
      1. The Savings Report p. 80
      2. The CD Report p. 86
      3. Savings Bond Report p. 90
      4. The Stock Report p. 92
9. 7. Creating an Account Summary Report
   1. Create the Value Fields
   2. Visit the Wizard
   3. Edit the Layout
10. 8. Buttons, Scripts, and Value Lists
    1. Define Value Lists
    2. Transaction Buttons
    3. Main Header Buttons
    4. Tab Panel Buttons
    5. Prev/Next Buttons
    6. Go to Tab Script
    7. Create More Scripts
    8. Organize the Scripts
    9. Assign Scripts to Buttons
    10. Set Calendars and Tabs
    11. Extra Bits
        1. Define Value Lists p. 102
        2. Transaction Buttons p. 105
        3. Main Header Buttons p. 108
        4. Tab Panel Buttons p. 110
        5. Prev/Next Buttons p. 111
        6. Go to Tab Script p. 112
        7. Create More Scripts p. 116
11. 9. Using the Database
    1. Create New Records
    2. Delete Records
    3. Common Procedures
    4. Extra Bits
       1. Create New Records p. 132
       2. Delete Records p. 134
       3. Common Procedures p. 135
12. 10. Updating to FileMaker Pro 8.5
    1. Add a Ticker Symbol Field
    2. Create the Quotes Tab
    3. Add the Web Viewer
    4. Name the Layout Objects
    5. Add Browser Buttons
    6. Fix the Go to Tab Script
    7. Use the Web Viewer
    8. Extra Bits
       1. The Ticker Symbol Field p. 140
       2. Add the Web Viewer p. 143
       3. Add Browser Buttons p. 147
       4. Use the Web Viewer p. 151