The Missing Credits |
|
ix | |
Introduction |
|
xv | |
Why FileMaker Pro? |
|
xvii | |
About This Book |
|
xviii | |
Macintosh and Windows |
|
xix | |
About the Outline |
|
xix | |
What's New in FileMaker Pro 13 |
|
xx | |
The Very Basics |
|
xxiv | |
About the Online Resources |
|
xxv | |
Safari® Books Online |
|
xxvi | |
|
Part One Getting Started with FileMaker |
|
|
|
Chapter 1 Working with Your Database |
|
|
3 | (34) |
|
A Very Quick Database Tour |
|
|
3 | (5) |
|
Opening and Closing Database Files |
|
|
8 | (3) |
|
Adding Data to Your Database |
|
|
11 | (6) |
|
|
17 | (3) |
|
|
20 | (5) |
|
|
25 | (4) |
|
Same Database, Different Views |
|
|
29 | (4) |
|
|
33 | (2) |
|
Using FileMaker's Help Menu |
|
|
35 | (2) |
|
Chapter 2 Organizing and Editing Records |
|
|
37 | (40) |
|
|
37 | (6) |
|
|
43 | (14) |
|
Editing What's in Your Fields |
|
|
57 | (6) |
|
|
63 | (5) |
|
|
68 | (3) |
|
Preview Mode and Printing |
|
|
71 | (6) |
|
Part Two Building Your First Database |
|
|
|
Chapter 3 Creating a Custom Database |
|
|
77 | (42) |
|
|
77 | (2) |
|
Creating and Managing Fields in Form View |
|
|
79 | (7) |
|
|
86 | (5) |
|
|
91 | (20) |
|
|
111 | (3) |
|
|
114 | (5) |
|
Chapter 4 Adding Power to Your Database |
|
|
119 | (54) |
|
Creating a Simple Calculation |
|
|
119 | (6) |
|
|
125 | (9) |
|
Creating and Using Portals |
|
|
134 | (9) |
|
|
143 | (8) |
|
|
151 | (3) |
|
|
154 | (6) |
|
Creating a Dynamic Report with the Assistant |
|
|
160 | (4) |
|
Creating a Trailing Group Report |
|
|
164 | (2) |
|
Creating Charts in Table View |
|
|
166 | (1) |
|
Changing the Default Account |
|
|
167 | (3) |
|
|
170 | (3) |
|
Part Three Thinking Like a Developer |
|
|
|
Chapter 5 Creating and Managing a Relational Database |
|
|
173 | (50) |
|
Understanding Relational Databases |
|
|
174 | (1) |
|
|
175 | (18) |
|
Creating a Relational Database |
|
|
193 | (8) |
|
Using Relational Database Power |
|
|
201 | (8) |
|
|
209 | (8) |
|
Reviewing Relationship Concepts |
|
|
217 | (6) |
|
|
223 | (30) |
|
Understanding Field Types |
|
|
224 | (3) |
|
|
227 | (7) |
|
|
234 | (6) |
|
|
240 | (7) |
|
Beyond Text: Container Fields |
|
|
247 | (6) |
|
Chapter 7 Layout Mechanics |
|
|
253 | (46) |
|
|
253 | (4) |
|
|
257 | (14) |
|
|
271 | (5) |
|
|
276 | (12) |
|
|
288 | (4) |
|
Creating Layouts for Printing |
|
|
292 | (7) |
|
|
299 | (50) |
|
|
299 | (1) |
|
|
300 | (1) |
|
|
300 | (4) |
|
Grids, Guides, and Dynamic Guides |
|
|
304 | (6) |
|
|
310 | (1) |
|
|
311 | (12) |
|
|
323 | (2) |
|
|
325 | (1) |
|
|
326 | (2) |
|
|
328 | (11) |
|
|
339 | (10) |
|
Chapter 9 Understanding Calculations |
|
|
349 | (32) |
|
Understanding Calculations |
|
|
349 | (18) |
|
Using a Related Field in a Calculation |
|
|
367 | (2) |
|
Understanding the Specify Calculation Dialog Box |
|
|
369 | (3) |
|
|
372 | (3) |
|
Validate Data Entry with a Calculation |
|
|
375 | (2) |
|
Commenting in Calculations |
|
|
377 | (4) |
|
Chapter 10 More Calculations and Data Types |
|
|
381 | (28) |
|
Number Crunching Calculations |
|
|
381 | (4) |
|
Going Beyond Basic Calculations |
|
|
385 | (3) |
|
|
388 | (13) |
|
Date and Time Calculations |
|
|
401 | (5) |
|
Containers in Calculations |
|
|
406 | (3) |
|
Chapter 11 Understanding Scripts |
|
|
409 | (44) |
|
|
410 | (1) |
|
|
410 | (12) |
|
Shortcuts to the Edit Script Window |
|
|
422 | (1) |
|
The Importance of the Layout |
|
|
423 | (1) |
|
|
424 | (4) |
|
|
428 | (3) |
|
Branching and Looping in Scripts |
|
|
431 | (9) |
|
|
440 | (13) |
|
Chapter 12 Exploring Script Steps |
|
|
453 | (56) |
|
|
453 | (1) |
|
|
454 | (3) |
|
|
457 | (16) |
|
|
473 | (9) |
|
|
482 | (10) |
|
|
492 | (1) |
|
|
493 | (8) |
|
|
501 | (2) |
|
|
503 | (1) |
|
|
503 | (6) |
|
Part Four Becoming a Power Developer |
|
|
|
Chapter 13 Applying Developer Utilities |
|
|
509 | (50) |
|
Copying and Pasting Database Structure |
|
|
510 | (3) |
|
|
513 | (8) |
|
|
521 | (4) |
|
|
525 | (1) |
|
The Database Design Report |
|
|
526 | (6) |
|
|
532 | (6) |
|
|
538 | (13) |
|
|
551 | (5) |
|
|
556 | (3) |
|
Chapter 14 Advanced Relationship Techniques |
|
|
559 | (38) |
|
|
560 | (7) |
|
|
567 | (3) |
|
Understanding Table Occurrences |
|
|
570 | (5) |
|
|
575 | (11) |
|
Understanding Graph Arrangements |
|
|
586 | (1) |
|
Connecting Database Files |
|
|
587 | (5) |
|
Using Multiple Relationship Techniques |
|
|
592 | (5) |
|
Chapter 15 Reporting and Analysis |
|
|
597 | (42) |
|
Summary Fields and Subsummary Parts |
|
|
597 | (11) |
|
|
608 | (6) |
|
|
614 | (5) |
|
Basic Charting (Found Set Charts) |
|
|
619 | (6) |
|
|
625 | (3) |
|
|
628 | (3) |
|
|
631 | (8) |
|
Chapter 16 Advanced Calculations |
|
|
639 | (28) |
|
Understanding Boolean Functions |
|
|
640 | (3) |
|
|
643 | (5) |
|
|
648 | (7) |
|
The Let() Function and Variables |
|
|
655 | (3) |
|
|
658 | (5) |
|
|
663 | (4) |
|
Chapter 17 Advanced Scripting |
|
|
667 | (58) |
|
|
667 | (2) |
|
|
669 | (1) |
|
Communicating with Database Users |
|
|
670 | (8) |
|
|
678 | (6) |
|
|
684 | (3) |
|
|
687 | (2) |
|
|
689 | (4) |
|
|
693 | (7) |
|
Putting a Complex Script Together |
|
|
700 | (25) |
|
Part Five Security and Integration |
|
|
|
Chapter 18 Adding Security |
|
|
725 | (36) |
|
|
725 | (2) |
|
|
727 | (18) |
|
|
745 | (5) |
|
|
750 | (3) |
|
Managing External File Access |
|
|
753 | (3) |
|
|
756 | (5) |
|
Chapter 19 Sharing Data Using FileMaker Server |
|
|
761 | (30) |
|
Understanding Database Sharing |
|
|
762 | (1) |
|
FileMaker Network Sharing |
|
|
762 | (3) |
|
Working with a Shared File |
|
|
765 | (4) |
|
|
769 | (20) |
|
|
789 | (2) |
|
Chapter 20 Sharing Data with WebDirect and FileMaker Go |
|
|
791 | (22) |
|
|
792 | (3) |
|
Enabling WebDirect in a Database |
|
|
795 | (3) |
|
Opening a Database in FileMaker Go |
|
|
798 | (4) |
|
Connecting with a Web Browser |
|
|
802 | (2) |
|
Designing for WebDirect and FileMaker Go |
|
|
804 | (3) |
|
|
807 | (1) |
|
|
808 | (2) |
|
Customizing the WebDirect Home Page |
|
|
810 | (1) |
|
Sharing Databases on the Internet Without WebDirect |
|
|
810 | (3) |
|
Chapter 21 Sharing Data with Other Systems |
|
|
813 | (48) |
|
Sharing Your Data with Others |
|
|
813 | (6) |
|
|
819 | (2) |
|
|
821 | (11) |
|
|
832 | (6) |
|
|
838 | (12) |
|
|
850 | (7) |
|
Importing and Exporting in a Script |
|
|
857 | (4) |
|
|
|
|
861 | (12) |
|
Getting Help from FileMaker Pro |
|
|
861 | (4) |
|
FileMaker's Installed Extras |
|
|
865 | (6) |
|
Getting Help from the Community |
|
|
871 | (2) |
|
Appendix B File Conversion |
|
|
873 | (6) |
|
|
873 | (1) |
|
|
874 | (1) |
|
|
875 | (1) |
|
|
875 | (3) |
|
Converting Multiple Files |
|
|
878 | (1) |
|
Appendix C Using the Insert Commands with Container Fields |
|
|
879 | (2) |
|
Appendix D FileMaker Error Codes |
|
|
881 | (10) |
Index |
|
891 | |