| Welcome to FileMaker Pro 7 |
|
1 | (1) |
|
Waiter, There's a Software Development Tool in My Productivity Application! |
|
|
2 | (2) |
|
Rapid Application Development |
|
|
3 | (1) |
|
Low Total Cost of Ownership |
|
|
3 | (1) |
|
FileMaker Is a Seasoned Pro |
|
|
3 | (1) |
|
|
|
4 | (1) |
|
How This Book Is Organized |
|
|
4 | (6) |
|
Part I: ``Getting Started with FileMaker 7'' |
|
|
4 | (1) |
|
Part II: ``Developing Solutions with FileMaker'' |
|
|
5 | (1) |
|
Part III: ``Developer Techniques'' |
|
|
6 | (1) |
|
Part IV: ``Data Integration and Publishing'' |
|
|
7 | (1) |
|
Part V: ``Deploying a FileMaker Solution'' |
|
|
8 | (1) |
|
|
|
8 | (1) |
|
Typographic Conventions Used in This Book |
|
|
9 | (1) |
|
|
|
9 | (1) |
|
|
|
10 | (3) |
|
I Getting Started with FileMaker 7 |
|
|
|
|
|
13 | (14) |
|
Introduction to Database Software |
|
|
14 | (4) |
|
Types of Database Software |
|
|
14 | (2) |
|
What Database Software Does |
|
|
16 | (2) |
|
Overview of the FileMaker 7 Product Line |
|
|
18 | (1) |
|
FileMaker Deployment Options |
|
|
19 | (2) |
|
|
|
19 | (1) |
|
|
|
19 | (1) |
|
|
|
20 | (1) |
|
FileMaker Server Advanced Hosting |
|
|
20 | (1) |
|
|
|
20 | (1) |
|
Extending the Functionality of FileMaker Pro |
|
|
20 | (1) |
|
What's New in FileMaker Pro 7 |
|
|
21 | (6) |
|
|
|
21 | (1) |
|
|
|
21 | (1) |
|
|
|
22 | (1) |
|
Enhanced Relationship Functionality |
|
|
23 | (1) |
|
Multiple Windows per File |
|
|
23 | (1) |
|
|
|
23 | (2) |
|
|
|
25 | (1) |
|
|
|
25 | (1) |
|
|
|
25 | (1) |
|
|
|
25 | (1) |
|
|
|
26 | (1) |
|
|
|
27 | (36) |
|
|
|
28 | (8) |
|
|
|
28 | (1) |
|
|
|
29 | (1) |
|
|
|
30 | (6) |
|
|
|
36 | (21) |
|
|
|
36 | (2) |
|
Creating a New Database from a Template |
|
|
38 | (1) |
|
Creating and Deleting Records |
|
|
38 | (1) |
|
|
|
39 | (3) |
|
|
|
42 | (2) |
|
|
|
44 | (1) |
|
Manipulating Records in Portals |
|
|
45 | (2) |
|
|
|
47 | (2) |
|
Using Find Mode to Perform a Find Request |
|
|
49 | (4) |
|
Omit and Show All Records |
|
|
53 | (1) |
|
|
|
54 | (1) |
|
|
|
55 | (1) |
|
Presenting Data with Subsummary Reports |
|
|
55 | (2) |
|
Importing and Exporting Data |
|
|
57 | (1) |
|
|
|
57 | (2) |
|
FileMaker Extra: Becoming a FileMaker Pro Power User |
|
|
59 | (4) |
|
Technique 1: Use Your Keyboard for More Speed |
|
|
59 | (1) |
|
Technique 2: Work with Table View |
|
|
59 | (1) |
|
Technique 3: Replacing Data |
|
|
59 | (1) |
|
Technique 4: Inserting Specific Information |
|
|
60 | (1) |
|
Technique 5: Get to Know Your Entire Database |
|
|
61 | (1) |
|
Technique 6: Multi-tiered Sorts |
|
|
61 | (1) |
|
Technique 7: Use Multiple Windows |
|
|
61 | (1) |
|
Technique 8: Text Styling and Tabs |
|
|
61 | (2) |
|
Defining and Working with Fields |
|
|
63 | (26) |
|
|
|
64 | (2) |
|
New Databases Begin with Field Definitions |
|
|
64 | (1) |
|
Using the Define Database Dialog |
|
|
64 | (2) |
|
|
|
66 | (3) |
|
|
|
66 | (2) |
|
Adding Field Comments New |
|
|
68 | (1) |
|
|
|
69 | (1) |
|
|
|
69 | (5) |
|
|
|
69 | (1) |
|
|
|
69 | (1) |
|
|
|
70 | (1) |
|
|
|
70 | (1) |
|
|
|
70 | (1) |
|
|
|
71 | (1) |
|
|
|
71 | (2) |
|
|
|
73 | (1) |
|
|
|
74 | (12) |
|
|
|
75 | (6) |
|
|
|
81 | (1) |
|
|
|
82 | (3) |
|
|
|
85 | (1) |
|
|
|
86 | (1) |
|
FileMaker Extra: Indexing in FileMaker Pro 7 |
|
|
87 | (2) |
|
FileMaker Fundamentals: Working with Layouts |
|
|
89 | (34) |
|
|
|
90 | (1) |
|
Creating and Managing Layouts |
|
|
91 | (8) |
|
|
|
91 | (2) |
|
|
|
93 | (1) |
|
|
|
94 | (3) |
|
Hiding and Reordering Layouts |
|
|
97 | (1) |
|
Restricting Access to Layouts |
|
|
98 | (1) |
|
|
|
99 | (4) |
|
Adding and Ordering Parts |
|
|
100 | (1) |
|
|
|
101 | (1) |
|
|
|
101 | (2) |
|
Working with Objects on a Layout |
|
|
103 | (11) |
|
Adding Objects to a Layout |
|
|
103 | (3) |
|
Positioning Objects on a Layout |
|
|
106 | (4) |
|
|
|
110 | (4) |
|
|
|
114 | (4) |
|
|
|
114 | (1) |
|
|
|
115 | (1) |
|
|
|
116 | (1) |
|
|
|
117 | (1) |
|
|
|
117 | (1) |
|
|
|
118 | (1) |
|
FileMaker Extra: Designing Cross-Platform-Friendly Layouts |
|
|
119 | (4) |
|
II Developing Solutions with FileMaker |
|
|
|
Relational Database Design |
|
|
123 | (30) |
|
Understanding Database Design |
|
|
124 | (1) |
|
|
|
124 | (1) |
|
Working with Entities and Attributes |
|
|
125 | (5) |
|
Entities Versus Attributes: A Case Study |
|
|
127 | (2) |
|
Design as an Iterative Process |
|
|
129 | (1) |
|
Understanding Relationships |
|
|
130 | (4) |
|
Representing Relationships in a Diagram |
|
|
130 | (1) |
|
|
|
131 | (3) |
|
|
|
134 | (1) |
|
|
|
134 | (4) |
|
Optionality in Many-to-Many Relationships |
|
|
134 | (2) |
|
Optionality in One-to-Many Relationships |
|
|
136 | (2) |
|
Optionality in One-to-One Relationships |
|
|
138 | (1) |
|
Understanding the Role of Keys in Database Design |
|
|
138 | (2) |
|
Keys That Determine Uniqueness |
|
|
139 | (1) |
|
Keys That Refer to Other Tables |
|
|
140 | (1) |
|
Many-to-Many Relationships: Solving the Puzzle |
|
|
140 | (3) |
|
Attributes in a Join Entity |
|
|
142 | (1) |
|
Additional Many-to-Many Examples |
|
|
143 | (1) |
|
The Basics of Process Analysis |
|
|
143 | (6) |
|
Process Analysis: Legal Documents |
|
|
144 | (5) |
|
FileMaker Extra: Complex Many-to-Many Relationships |
|
|
149 | (4) |
|
Working with Multiple Tables |
|
|
153 | (26) |
|
Multi-table Systems in FileMaker Pro |
|
|
154 | (1) |
|
Creating a One-to-Many Relationship in FileMaker |
|
|
154 | (4) |
|
Creating the First Table in a Multi-table System |
|
|
155 | (1) |
|
Adding a Table to a Multi-table System |
|
|
155 | (2) |
|
|
|
157 | (1) |
|
Working with Keys and Match Fields |
|
|
158 | (3) |
|
Understanding Table Context |
|
|
161 | (1) |
|
Working with Related Data |
|
|
162 | (6) |
|
Using a Portal to View Related Child Data |
|
|
162 | (2) |
|
Using a Portal to Add Related Records |
|
|
164 | (2) |
|
Working with Related Parent Data in a Child File |
|
|
166 | (2) |
|
Portals Versus Related Fields: Which Is Which? |
|
|
168 | (1) |
|
Creating a Many-to-Many Relationship |
|
|
168 | (5) |
|
|
|
168 | (1) |
|
Creating a Data Entry Interface |
|
|
169 | (1) |
|
Using a Value List for Data Entry |
|
|
170 | (3) |
|
|
|
173 | (2) |
|
Using a Value List to Ensure Relational Integrity |
|
|
173 | (1) |
|
Preserving Referential Integrity During Deletion |
|
|
174 | (1) |
|
|
|
175 | (1) |
|
FileMaker Extra: Building a Three-Way Join |
|
|
176 | (3) |
|
Working with Relationships |
|
|
179 | (34) |
|
Relationship Graphs and ERDs |
|
|
180 | (1) |
|
|
|
180 | (7) |
|
|
|
181 | (2) |
|
Adding a Table Occurrence to the Relationships Graph |
|
|
183 | (2) |
|
Defining a Relationship with Multiple Match Criteria |
|
|
185 | (2) |
|
Creating Self-Relationships |
|
|
187 | (6) |
|
Managers and Employees: A ``Structural'' Self-Relationship |
|
|
187 | (4) |
|
An ``Exclusionary'' Self-Relationship |
|
|
191 | (2) |
|
Creating Ranged Relationships |
|
|
193 | (2) |
|
Creating Cross-Product Relationships |
|
|
195 | (1) |
|
Working with Data from Distant Tables New |
|
|
196 | (1) |
|
Working with Multiple Files |
|
|
197 | (6) |
|
Creating a File Reference |
|
|
198 | (3) |
|
Adding an External Table to the Relationships Graph |
|
|
201 | (2) |
|
How and When to Use Multiple Files |
|
|
203 | (6) |
|
Working with Converted Files |
|
|
203 | (1) |
|
Separation of a System into Modules |
|
|
204 | (5) |
|
|
|
209 | (1) |
|
FileMaker Extra: Managing the Relationships Graph |
|
|
210 | (3) |
|
Getting Started with Calculations |
|
|
213 | (28) |
|
Understanding How and Where Calculations Are Used |
|
|
214 | (2) |
|
Writing Calculation Formulas |
|
|
214 | (1) |
|
Uses for Calculation Formulas |
|
|
215 | (1) |
|
Exploring the Calculation Dialog Box |
|
|
216 | (7) |
|
|
|
217 | (1) |
|
|
|
217 | (3) |
|
|
|
220 | (3) |
|
|
|
223 | (11) |
|
|
|
223 | (2) |
|
|
|
225 | (4) |
|
|
|
229 | (1) |
|
|
|
230 | (2) |
|
Working with Dates and Times |
|
|
232 | (2) |
|
Using Conditional Functions |
|
|
234 | (1) |
|
|
|
235 | (1) |
|
Learning About the Environment |
|
|
235 | (3) |
|
|
|
235 | (2) |
|
|
|
237 | (1) |
|
|
|
238 | (1) |
|
FileMaker Extra: Tips for Becoming a Calculation Master |
|
|
239 | (2) |
|
Getting Started with Scripting |
|
|
241 | (28) |
|
|
|
242 | (1) |
|
|
|
243 | (6) |
|
|
|
243 | (2) |
|
|
|
245 | (1) |
|
|
|
246 | (1) |
|
|
|
246 | (1) |
|
|
|
247 | (1) |
|
|
|
248 | (1) |
|
|
|
248 | (1) |
|
Common Scripting Techniques |
|
|
249 | (15) |
|
|
|
249 | (2) |
|
Setting and Controlling Data |
|
|
251 | (1) |
|
Providing User Navigation |
|
|
252 | (2) |
|
|
|
254 | (3) |
|
|
|
257 | (2) |
|
|
|
259 | (2) |
|
Working with Custom Dialogs |
|
|
261 | (3) |
|
|
|
264 | (1) |
|
Working with Buttons on Layouts |
|
|
264 | (1) |
|
|
|
265 | (1) |
|
FileMaker Extra: Creating a Script Library |
|
|
266 | (3) |
|
Reporting with Grouped Data |
|
|
269 | (28) |
|
Deriving Meaning from Data |
|
|
270 | (3) |
|
Begin with the End in Mind |
|
|
270 | (1) |
|
Determine Report Requirements |
|
|
271 | (1) |
|
Generic Versus Specific Report Structures |
|
|
272 | (1) |
|
Working with Lists of Data |
|
|
273 | (8) |
|
|
|
274 | (1) |
|
Alternating Row Color New |
|
|
275 | (1) |
|
Horizontal and Vertical Dividers |
|
|
276 | (2) |
|
|
|
278 | (3) |
|
|
|
281 | (1) |
|
|
|
281 | (11) |
|
|
|
282 | (1) |
|
Creating a Subsummary Report |
|
|
282 | (3) |
|
Using Summary Fields in Subsummary Reports |
|
|
285 | (2) |
|
Calculations Involving Summary Fields |
|
|
287 | (1) |
|
Summarizing on Multiple Criteria |
|
|
288 | (1) |
|
Reordering a Report Based on Summary Data |
|
|
289 | (1) |
|
Subsummary Reports with No Body Part |
|
|
290 | (2) |
|
|
|
292 | (1) |
|
FileMaker Extra: Incorporating Reports into the Workflow |
|
|
293 | (4) |
|
|
|
|
Developing for Multi-User Deployment |
|
|
297 | (18) |
|
Developing for Multiple Users |
|
|
298 | (1) |
|
``Sessions'' in FileMaker Pro |
|
|
298 | (2) |
|
Session-Specific Elements |
|
|
299 | (1) |
|
|
|
299 | (1) |
|
User Accounts and Session Data |
|
|
300 | (1) |
|
|
|
300 | (5) |
|
|
|
300 | (2) |
|
|
|
302 | (1) |
|
Commit Versus Create and Serial IDs |
|
|
302 | (1) |
|
|
|
303 | (2) |
|
Audit Trails in FileMaker Pro |
|
|
305 | (5) |
|
Record Create/Modify Meta Data |
|
|
306 | (1) |
|
Script-Controlled Editing |
|
|
306 | (1) |
|
Auto-Entry Technique for Audit Trails |
|
|
307 | (3) |
|
Creating Rollback Functionality |
|
|
310 | (1) |
|
|
|
310 | (1) |
|
|
|
311 | (1) |
|
FileMaker Extra: Development with a Team New |
|
|
312 | (3) |
|
|
|
315 | (38) |
|
FileMaker Security Features Overview |
|
|
316 | (22) |
|
|
|
316 | (9) |
|
|
|
325 | (11) |
|
|
|
336 | (2) |
|
FileMaker Server Security Features |
|
|
338 | (8) |
|
|
|
339 | (3) |
|
Directory Service Integration |
|
|
342 | (4) |
|
Assessing the Security Risk |
|
|
346 | (1) |
|
Developing a Security Plan |
|
|
347 | (2) |
|
|
|
349 | (1) |
|
FileMaker Extra: Configuring External Authentication Servers for Mac OS X |
|
|
350 | (3) |
|
Advanced Layout Techniques |
|
|
353 | (28) |
|
User Interfaces in FileMaker Pro |
|
|
354 | (4) |
|
FileMaker's Native User Interface |
|
|
356 | (1) |
|
Building Your Own Interface |
|
|
357 | (1) |
|
|
|
357 | (1) |
|
Single File Interface Versus Distributed Interface |
|
|
357 | (1) |
|
|
|
358 | (9) |
|
|
|
358 | (8) |
|
Other Navigation Techniques |
|
|
366 | (1) |
|
Multi-Window Interfaces New |
|
|
367 | (4) |
|
Tool and Function Palettes |
|
|
367 | (1) |
|
|
|
368 | (2) |
|
|
|
370 | (1) |
|
Showing/Hiding Contextual Layout Elements |
|
|
371 | (3) |
|
|
|
374 | (2) |
|
Dedicated Find Mode Layouts |
|
|
375 | (1) |
|
|
|
375 | (1) |
|
|
|
376 | (1) |
|
|
|
376 | (1) |
|
|
|
376 | (1) |
|
|
|
377 | (1) |
|
|
|
378 | (1) |
|
FileMaker Extra: User Interface Heuristics |
|
|
379 | (2) |
|
Specialized Calculation Functions |
|
|
381 | (40) |
|
What's a Specialized Function? |
|
|
382 | (1) |
|
|
|
382 | (16) |
|
|
|
382 | (2) |
|
|
|
384 | (2) |
|
|
|
386 | (3) |
|
The Evaluate Function New |
|
|
389 | (6) |
|
|
|
395 | (3) |
|
Text Formatting Functions |
|
|
398 | (5) |
|
Text Color, Font, and Size |
|
|
399 | (1) |
|
|
|
399 | (1) |
|
Examples Involving Text Formatting Functions |
|
|
400 | (3) |
|
|
|
403 | (3) |
|
Working with Return-Delimited Data Arrays New |
|
|
404 | (1) |
|
Stepping Through an Array |
|
|
405 | (1) |
|
The ``Filter''-ing Functions New |
|
|
406 | (3) |
|
|
|
406 | (2) |
|
The FilterValues Function |
|
|
408 | (1) |
|
|
|
409 | (9) |
|
|
|
409 | (2) |
|
Creating Custom Functions |
|
|
411 | (3) |
|
Examples of Custom Functions |
|
|
414 | (4) |
|
|
|
418 | (1) |
|
FileMaker Extra: Creating a Custom Function Library |
|
|
419 | (2) |
|
|
|
421 | (24) |
|
What Is Advanced Scripting? |
|
|
422 | (1) |
|
|
|
422 | (8) |
|
Specifying Script Parameters |
|
|
423 | (1) |
|
Retrieving a Script Parameter |
|
|
423 | (1) |
|
Passing Multi-valued Parameters |
|
|
424 | (4) |
|
Strategies for Using Script Parameters |
|
|
428 | (2) |
|
Window Management Techniques New |
|
|
430 | (7) |
|
|
|
430 | (3) |
|
Positioning a Window Relative to Another Window |
|
|
433 | (4) |
|
|
|
437 | (5) |
|
|
|
437 | (2) |
|
|
|
439 | (2) |
|
Jumping to Disconnected Table Occurrences |
|
|
441 | (1) |
|
|
|
442 | (1) |
|
FileMaker Extra: Recursive Scripts |
|
|
443 | (2) |
|
|
|
445 | (30) |
|
|
|
446 | (1) |
|
|
|
446 | (6) |
|
Portals Versus List View/Table View |
|
|
447 | (1) |
|
|
|
448 | (2) |
|
|
|
450 | (1) |
|
|
|
451 | (1) |
|
Scripted New Portal Records |
|
|
452 | (1) |
|
``New Record Only'' Relationships |
|
|
452 | (2) |
|
|
|
454 | (1) |
|
|
|
454 | (8) |
|
|
|
455 | (3) |
|
|
|
458 | (2) |
|
Multi-keys and Multi-row Selections |
|
|
460 | (2) |
|
|
|
462 | (6) |
|
Multi-value ``and'' Filtered Portals |
|
|
464 | (1) |
|
Multi-value ``or'' Filtered Portals |
|
|
464 | (1) |
|
Ranged, Multi-value ``or'' Filtered Portals |
|
|
465 | (1) |
|
Exploded Key Filtered Portals |
|
|
466 | (2) |
|
|
|
468 | (4) |
|
Multiple Field Type Portal Sorting |
|
|
470 | (1) |
|
Descending Dynamic Portal Sorting |
|
|
471 | (1) |
|
|
|
472 | (2) |
|
FileMaker Extra: Portals and Record Locking New |
|
|
474 | (1) |
|
|
|
475 | (32) |
|
|
|
476 | (1) |
|
|
|
476 | (8) |
|
Understand Software Requirements |
|
|
476 | (1) |
|
|
|
477 | (7) |
|
|
|
484 | (1) |
|
Troubleshooting Scripts and Calculations |
|
|
485 | (7) |
|
Handling Errors in Scripts |
|
|
486 | (2) |
|
|
|
488 | (4) |
|
Troubleshooting in Specific Areas: Performance, Context, Connectivity, and Globals |
|
|
492 | (11) |
|
|
|
492 | (3) |
|
Connectivity and Related Issues |
|
|
495 | (3) |
|
|
|
498 | (4) |
|
|
|
502 | (1) |
|
File Maintenance and Recovery |
|
|
503 | (1) |
|
|
|
503 | (1) |
|
|
|
504 | (1) |
|
FileMaker Extra: Other Tools of the Trade |
|
|
504 | (3) |
|
Converting Systems from Previous Versions of FileMaker Pro |
|
|
507 | (30) |
|
|
|
508 | (5) |
|
Factors Influencing Your Migration Strategy |
|
|
508 | (5) |
|
|
|
513 | (1) |
|
|
|
513 | (3) |
|
Converting Single-File Solutions |
|
|
514 | (1) |
|
Converting Relational Solutions |
|
|
515 | (1) |
|
|
|
516 | (6) |
|
|
|
516 | (1) |
|
|
|
517 | (1) |
|
|
|
518 | (3) |
|
|
|
521 | (1) |
|
|
|
522 | (9) |
|
|
|
522 | (3) |
|
|
|
525 | (1) |
|
|
|
526 | (2) |
|
|
|
528 | (3) |
|
|
|
531 | (1) |
|
FileMaker Extra: Converting Web-Enabled Databases |
|
|
532 | (5) |
|
|
|
532 | (1) |
|
|
|
532 | (5) |
|
IV Data Integration and Publishing |
|
|
|
Importing Data into FileMaker Pro |
|
|
537 | (26) |
|
Working with External Data |
|
|
538 | (1) |
|
|
|
538 | (9) |
|
Choosing the Target Table |
|
|
538 | (1) |
|
|
|
538 | (1) |
|
The Import Field Mapping Dialog |
|
|
539 | (4) |
|
Updating Records with Imported Data |
|
|
543 | (2) |
|
Special Flat File Formats |
|
|
545 | (2) |
|
Importing Multiple Files from a Folder |
|
|
547 | (4) |
|
|
|
547 | (2) |
|
|
|
549 | (2) |
|
Importing Photos from a Digital Camera |
|
|
551 | (1) |
|
Importing from an ODBC Data Source |
|
|
552 | (7) |
|
|
|
553 | (1) |
|
|
|
554 | (1) |
|
|
|
555 | (2) |
|
Performing the ODBC Import |
|
|
557 | (2) |
|
Importing from an XML Data Source |
|
|
559 | (1) |
|
Using a Script to Import Data |
|
|
559 | (1) |
|
|
|
560 | (1) |
|
FileMaker Extra: Exploiting the FileMaker-to-FileMaker Import |
|
|
561 | (2) |
|
|
|
561 | (1) |
|
Duplicating Between Tables |
|
|
561 | (2) |
|
Getting Data Out of FileMaker |
|
|
563 | (42) |
|
Reasons for Exporting Data |
|
|
564 | (1) |
|
Fundamentals of Exporting Data |
|
|
564 | (2) |
|
Exporting with Layout Formatting |
|
|
566 | (6) |
|
Fixed-Length Field Exporting |
|
|
572 | (2) |
|
|
|
574 | (1) |
|
|
|
574 | (2) |
|
|
|
576 | (2) |
|
Accessing FileMaker Data Using ODBC/JDBC |
|
|
578 | (21) |
|
Setting Up FileMaker Pro to Host an ODBC/JDBC Session |
|
|
579 | (4) |
|
Setting up FileMaker Server 7 Advanced to Host Multiple ODBC/JDBC Sessions |
|
|
583 | (3) |
|
Configuring a Data Source Name for ODBC |
|
|
586 | (4) |
|
Using FileMaker Pro as an ODBC Client |
|
|
590 | (9) |
|
|
|
599 | (1) |
|
FilmMaker Extra: Installing and Troubleshooting the ODBC Client Driver |
|
|
600 | (5) |
|
|
|
605 | (34) |
|
Instant Web Publishing--An Overview |
|
|
606 | (4) |
|
|
|
606 | (1) |
|
IWP Improvements in FileMaker Pro 7 New |
|
|
607 | (1) |
|
|
|
608 | (1) |
|
|
|
609 | (1) |
|
Enabling and Configuring IWP |
|
|
610 | (9) |
|
Configuring FileMaker Pro for IWP |
|
|
610 | (3) |
|
Configuring FileMaker Server 7 Advanced for IWP New |
|
|
613 | (3) |
|
Sharing and Securing Files Via IWP |
|
|
616 | (3) |
|
Designing for IWP Deployment |
|
|
619 | (14) |
|
|
|
619 | (1) |
|
|
|
620 | (3) |
|
|
|
623 | (3) |
|
|
|
626 | (1) |
|
|
|
627 | (6) |
|
|
|
633 | (2) |
|
|
|
633 | (1) |
|
|
|
634 | (1) |
|
|
|
634 | (1) |
|
|
|
635 | (1) |
|
|
|
635 | (1) |
|
FileMaker Extra: Building Your Own Next and Previous Page Buttons |
|
|
636 | (3) |
|
FileMaker and Web Services |
|
|
639 | (32) |
|
|
|
640 | (1) |
|
|
|
641 | (5) |
|
|
|
641 | (1) |
|
|
|
642 | (4) |
|
|
|
646 | (7) |
|
Introducing XSL Stylesheets |
|
|
647 | (2) |
|
|
|
649 | (3) |
|
Applying an Export Transformation to FileMaker XML |
|
|
652 | (1) |
|
XML Import: Understanding Web Services |
|
|
653 | (7) |
|
FileMaker's XML Import Capability |
|
|
653 | (1) |
|
|
|
654 | (1) |
|
A Stylesheet for XML Import |
|
|
655 | (5) |
|
Working with Web Services |
|
|
660 | (5) |
|
Accessing the Amazon Web Services |
|
|
660 | (1) |
|
Writing a Stylesheet to Import Amazon Data |
|
|
661 | (3) |
|
Building a More Flexible Interface to a Web Service |
|
|
664 | (1) |
|
Using FileMaker as a Web Services Source |
|
|
665 | (1) |
|
|
|
666 | (1) |
|
FileMaker Extra: Write Your Own Web Services |
|
|
667 | (4) |
|
|
|
671 | (58) |
|
About Custom Web Publishing New |
|
|
672 | (1) |
|
Custom Web Publishing Versus Instant Web Publishing |
|
|
673 | (1) |
|
Custom Web Publishing Versus XML Export |
|
|
674 | (1) |
|
Getting Your Databases Ready for Custom Web Publishing |
|
|
675 | (1) |
|
Setting Up the Server-Side Components for CWP |
|
|
676 | (7) |
|
Installing the Web Publishing Engine |
|
|
676 | (2) |
|
Configuring the Web Publishing Engine |
|
|
678 | (5) |
|
Publishing FileMaker Data as XML |
|
|
683 | (9) |
|
Introduction to XML Publishing |
|
|
683 | (3) |
|
Understanding Query Strings |
|
|
686 | (1) |
|
Performing Specific Searches with CWP URLs |
|
|
687 | (4) |
|
Applications of Custom Web Publishing with XML |
|
|
691 | (1) |
|
Using XSLT with Custom Web Publishing |
|
|
692 | (4) |
|
|
|
692 | (1) |
|
Getting Started with XSLT in CWP |
|
|
692 | (1) |
|
A Simple Stylesheet to Display Search Results |
|
|
693 | (2) |
|
|
|
695 | (1) |
|
Embedding Query Parameters in a Stylesheet |
|
|
696 | (1) |
|
Building Web Applications with XSLT-CWP |
|
|
696 | (19) |
|
Building a ``View Detail'' Link |
|
|
697 | (4) |
|
Using Tokens to Share Data Between Stylesheets |
|
|
701 | (7) |
|
Using a Stylesheet to Delete a Record |
|
|
708 | (5) |
|
Using Stylesheets to Create and Edit Records |
|
|
713 | (2) |
|
Other Custom Web Publishing Commands and Parameters |
|
|
715 | (3) |
|
|
|
715 | (1) |
|
|
|
716 | (2) |
|
About the FileMaker XSLT Extensions |
|
|
718 | (1) |
|
|
|
719 | (1) |
|
|
|
720 | (1) |
|
FileMaker Extra: About the Custom Web Publishing Tools |
|
|
721 | (8) |
|
|
|
722 | (1) |
|
|
|
722 | (2) |
|
Learning How to Program with CWP |
|
|
724 | (5) |
|
V Deploying a FileMaker Solution |
|
|
|
FileMaker Deployment Options |
|
|
729 | (8) |
|
FileMaker Deployment Options |
|
|
730 | (1) |
|
|
|
730 | (1) |
|
|
|
731 | (1) |
|
|
|
731 | (1) |
|
|
|
732 | (1) |
|
|
|
733 | (1) |
|
|
|
733 | (1) |
|
|
|
734 | (1) |
|
Deploying to Handheld Devices |
|
|
735 | (2) |
|
|
|
737 | (40) |
|
|
|
738 | (5) |
|
The FileMaker Server Product Line |
|
|
738 | (1) |
|
FileMaker Server Versus Peer-to-Peer Database Hosting |
|
|
738 | (1) |
|
FileMaker Server Capabilities |
|
|
739 | (1) |
|
FileMaker Server Requirements |
|
|
740 | (3) |
|
Installing FileMaker Server |
|
|
743 | (1) |
|
|
|
743 | (1) |
|
Starting and Stopping FileMaker Server |
|
|
743 | (1) |
|
|
|
744 | (1) |
|
Using the Server Administration Tool |
|
|
744 | (2) |
|
Configuring and Administering FileMaker Server Using the SAT |
|
|
746 | (2) |
|
Server Administration Settings |
|
|
746 | (1) |
|
|
|
747 | (1) |
|
Client Connectivity Settings |
|
|
748 | (1) |
|
|
|
748 | (1) |
|
|
|
749 | (1) |
|
Administration from the Command Line |
|
|
750 | (4) |
|
|
|
750 | (1) |
|
|
|
751 | (2) |
|
Scripting FileMaker Server Administrative Tasks |
|
|
753 | (1) |
|
Working with External Services |
|
|
754 | (6) |
|
Registering with an LDAP Server |
|
|
754 | (6) |
|
Using External Authentication Services |
|
|
760 | (1) |
|
Automatically Updating Plug-ins |
|
|
760 | (8) |
|
Preparing FileMaker Server |
|
|
761 | (1) |
|
|
|
762 | (1) |
|
Performing the Auto Update |
|
|
763 | (4) |
|
|
|
767 | (1) |
|
|
|
768 | (3) |
|
|
|
769 | (1) |
|
|
|
770 | (1) |
|
Sending Messages to Users |
|
|
770 | (1) |
|
Monitoring FileMaker Server |
|
|
771 | (3) |
|
Working with Usage Statistics |
|
|
771 | (1) |
|
Working with Application Events |
|
|
772 | (2) |
|
|
|
774 | (1) |
|
FileMaker Extra: Best Practices Checklist |
|
|
774 | (3) |
|
Determine Network Infrastructure |
|
|
775 | (1) |
|
|
|
775 | (1) |
|
|
|
775 | (1) |
|
Configure FileMaker Server |
|
|
775 | (1) |
|
Deploy Databases and Schedule Backups |
|
|
776 | (1) |
|
|
|
776 | (1) |
|
|
|
776 | (1) |
|
Perform Regular File Maintenance |
|
|
776 | (1) |
|
Keep Current with Software Updates |
|
|
776 | (1) |
|
FileMaker Developer and Plug-ins |
|
|
777 | (256) |
|
|
|
778 | (11) |
|
|
|
778 | (2) |
|
|
|
780 | (1) |
|
|
|
781 | (8) |
|
|
|
789 | (1) |
|
|
|
789 | (1) |
|
|
|
789 | (4) |
|
|
|
790 | (1) |
|
Using FileMaker's Sample Plug-in |
|
|
791 | (1) |
|
|
|
791 | (1) |
|
Deploying Plug-ins via FileMaker Server |
|
|
791 | (1) |
|
Configuring and Enabling Plug-ins |
|
|
792 | (1) |
|
|
|
793 | (1) |
|
FileMaker Extra: The Limits of Customization |
|
|
794 | (5) |
|
Lack of Multi-user Capability |
|
|
794 | (1) |
|
Lack of Menu Customization |
|
|
794 | (1) |
|
|
|
795 | (4) |
|
|
|
|
|
|
799 | (8) |
|
General Information on Relational Databases |
|
|
800 | (1) |
|
Data Modeling and Database Design |
|
|
800 | (1) |
|
Running a FileMaker Consulting Practice |
|
|
801 | (1) |
|
General Resources for Tips and Tricks |
|
|
801 | (1) |
|
Hosting FileMaker Databases on the Web |
|
|
802 | (1) |
|
|
|
802 | (1) |
|
|
|
802 | (2) |
|
|
|
804 | (1) |
|
|
|
805 | (1) |
|
|
|
805 | (1) |
|
|
|
806 | (1) |
|
B Calculation Function Reference |
|
|
807 | (120) |
|
|
|
927 | (96) |
|
About the Script Step Reference |
|
|
927 | (96) |
|
D Documenting FileMaker Pro Systems |
|
|
1023 | (10) |
|
Why Is Documentation Important? |
|
|
1024 | (1) |
|
Developing Naming Conventions |
|
|
1024 | (1) |
|
Using Comments Effectively |
|
|
1025 | (1) |
|
Adding Comments for Fields New |
|
|
1025 | (1) |
|
Commenting Within Formulas New |
|
|
1025 | (1) |
|
|
|
1026 | (1) |
|
Adding Descriptions in the Accounts & Privileges Dialog New |
|
|
1026 | (1) |
|
Documenting the Relationships Graph |
|
|
1026 | (1) |
|
Using the Database Design Report |
|
|
1027 | (1) |
|
|
|
1027 | (1) |
|
Working with the DDR in HTML |
|
|
1028 | (1) |
|
|
|
1029 | (1) |
|
Using Third-Party Documentation Tools |
|
|
1030 | (1) |
|
Putting the Finishing Touches on Your Documentation |
|
|
1031 | (1) |
|
Final Thoughts on Documentation |
|
|
1032 | (1) |
| Index |
|
1033 | |
