Special Edition Using FileMaker 7

by Lane, Steve; Bowers, Bob; Love, Scott; Moyer, Chris

• ISBN13: 9780789730282
• ISBN10: 0789730286
• Edition: CD
• Format: Paperback
• Copyright: 2005-01-01
• Publisher: Que

Summary

Once upon a time, you were an experienced FileMaker user. Now there's an updated version of the software and you feel like you're back at the beginning of the story.Special Edition Using FileMaker 7can help you get back to "happily ever after" with your database building skills. Frequent tips, case studies and thorough examples create a learning experience as if you were in the same room with the experienced FileMaker developers. Written byThe Moyer Group, a leading FileMaker Pro consulting and training organization, this book will show you how to avoid mistakes and save time in developing databases. A CD is included to show you sample files with before-and-after examples, as well as an interface explorer tool that will allow you to prototype interfaces quickly for clients.Special Edition Using FileMaker 7is sure to keep you from seeing the end of your database building days.

Table of Contents

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)
You're Not Alone	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)
Special Features	8	(1)
Typographic Conventions Used in This Book	9	(1)
Who Should Use This Book	9	(1)
A Brave, New World	10	(3)
I Getting Started with FileMaker 7
FileMaker Overview	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)
Single User	19	(1)
Peer-to-Peer Hosting	19	(1)
FileMaker Server Hosting	20	(1)
FileMaker Server Advanced Hosting	20	(1)
Kiosk Mode	20	(1)
Extending the Functionality of FileMaker Pro	20	(1)
What's New in FileMaker Pro 7	21	(6)
Technical Specifications	21	(1)
File Format	21	(1)
Relationships Graph	22	(1)
Enhanced Relationship Functionality	23	(1)
Multiple Windows per File	23	(1)
Security	23	(2)
Calculations	25	(1)
Scripts	25	(1)
Layouts	25	(1)
Web	25	(1)
Server	26	(1)
Using FileMaker Pro	27	(36)
Getting Started	28	(8)
Records and Fields	28	(1)
Tables	29	(1)
FileMaker Pro Navigation	30	(6)
Working in FileMaker Pro	36	(21)
Opening a Database	36	(2)
Creating a New Database from a Template	38	(1)
Creating and Deleting Records	38	(1)
Working with Fields	39	(3)
Field Types	42	(2)
Data Validation	44	(1)
Manipulating Records in Portals	45	(2)
Working with a Found Set	47	(2)
Using Find Mode to Perform a Find Request	49	(4)
Omit and Show All Records	53	(1)
Sorting	54	(1)
Printing	55	(1)
Presenting Data with Subsummary Reports	55	(2)
Importing and Exporting Data	57	(1)
Troubleshooting	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)
Working Under the Hood	64	(2)
New Databases Begin with Field Definitions	64	(1)
Using the Define Database Dialog	64	(2)
Working with Fields	66	(3)
Field Naming Conventions	66	(2)
Adding Field Comments New	68	(1)
Creating New Fields	69	(1)
Working with Field Types	69	(5)
Text	69	(1)
Number	69	(1)
Date	70	(1)
Time	70	(1)
Timestamp	70	(1)
Container	71	(1)
Calculation	71	(2)
Summary	73	(1)
Assigning Field Options	74	(12)
Auto-Entry Field Options	75	(6)
Field Validation	81	(1)
Storage and Indexing	82	(3)
Furigana	85	(1)
Troubleshooting	86	(1)
FileMaker Extra: Indexing in FileMaker Pro 7	87	(2)
FileMaker Fundamentals: Working with Layouts	89	(34)
What's a Layout?	90	(1)
Creating and Managing Layouts	91	(8)
Creating a New Layout	91	(2)
Layout Context New	93	(1)
Layout Setup	94	(3)
Hiding and Reordering Layouts	97	(1)
Restricting Access to Layouts	98	(1)
Working with Parts	99	(4)
Adding and Ordering Parts	100	(1)
Formatting a Part	101	(1)
Part Definition	101	(2)
Working with Objects on a Layout	103	(11)
Adding Objects to a Layout	103	(3)
Positioning Objects on a Layout	106	(4)
Arranging Objects	110	(4)
Working with Fields	114	(4)
Adding Fields to Layouts	114	(1)
Field Formatting	115	(1)
Field Behavior New	116	(1)
Setting the Tab Order	117	(1)
Merge Fields	117	(1)
Troubleshooting	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)
Database Analysis	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)
Relationship Types	131	(3)
Relationship Cardinality	134	(1)
Relationship Optionality	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)
Adding a Relationship	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)
Building the Structure	168	(1)
Creating a Data Entry Interface	169	(1)
Using a Value List for Data Entry	170	(3)
Relational Integrity	173	(2)
Using a Value List to Ensure Relational Integrity	173	(1)
Preserving Referential Integrity During Deletion	174	(1)
Troubleshooting	175	(1)
FileMaker Extra: Building a Three-Way Join	176	(3)
Working with Relationships	179	(34)
Relationship Graphs and ERDs	180	(1)
Relationships as Queries	180	(7)
Non-Equijoins	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)
Troubleshooting	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)
Specifying Context New	217	(1)
Writing the Formula	217	(3)
Other Options	220	(3)
Essential Functions	223	(11)
The Parts of a Function	223	(2)
Text Operations	225	(4)
Nested Functions	229	(1)
Number Functions	230	(2)
Working with Dates and Times	232	(2)
Using Conditional Functions	234	(1)
Aggregate Functions	235	(1)
Learning About the Environment	235	(3)
Get Functions	235	(2)
Design Functions	237	(1)
Troubleshooting	238	(1)
FileMaker Extra: Tips for Becoming a Calculation Master	239	(2)
Getting Started with Scripting	241	(28)
Scripts in FileMaker Pro	242	(1)
Creating Scripts	243	(6)
Topology of ScriptMaker	243	(2)
Script Naming Practices	245	(1)
Script Editing	246	(1)
Full Access Privileges	246	(1)
Commenting Scripts	247	(1)
Using a Script Template	248	(1)
Using Subscripts	248	(1)
Common Scripting Techniques	249	(15)
Error Management	249	(2)
Setting and Controlling Data	251	(1)
Providing User Navigation	252	(2)
Saved Script Options	254	(3)
Using Conditional Logic	257	(2)
Using Loops	259	(2)
Working with Custom Dialogs	261	(3)
Triggering Scripts	264	(1)
Working with Buttons on Layouts	264	(1)
Troubleshooting	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)
Trailing Summaries	274	(1)
Alternating Row Color New	275	(1)
Horizontal and Vertical Dividers	276	(2)
Sortable Column Headers	278	(3)
Go to Detail	281	(1)
Summarized Reports	281	(11)
Using a Break Field	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)
Troubleshooting	292	(1)
FileMaker Extra: Incorporating Reports into the Workflow	293	(4)
III Developer Techniques
Developing for Multi-User Deployment	297	(18)
Developing for Multiple Users	298	(1)
``Sessions'' in FileMaker Pro	298	(2)
Session-Specific Elements	299	(1)
Global Behavior	299	(1)
User Accounts and Session Data	300	(1)
Concurrency	300	(5)
The ACID Test	300	(2)
Script Log	302	(1)
Commit Versus Create and Serial IDs	302	(1)
Record Locking	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)
Launch Files	310	(1)
Troubleshooting	311	(1)
FileMaker Extra: Development with a Team New	312	(3)
Implementing Security	315	(38)
FileMaker Security Features Overview	316	(22)
Accounts New	316	(9)
Privilege Sets New	325	(11)
Extended Privileges New	336	(2)
FileMaker Server Security Features	338	(8)
Administration Security	339	(3)
Directory Service Integration	342	(4)
Assessing the Security Risk	346	(1)
Developing a Security Plan	347	(2)
Troubleshooting	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)
Interface Look and Feel	357	(1)
Single File Interface Versus Distributed Interface	357	(1)
Navigation	358	(9)
Tabbed Navigation	358	(8)
Other Navigation Techniques	366	(1)
Multi-Window Interfaces New	367	(4)
Tool and Function Palettes	367	(1)
Rich Dialog Windows	368	(2)
Special Effects	370	(1)
Showing/Hiding Contextual Layout Elements	371	(3)
Dedicated Find Layouts	374	(2)
Dedicated Find Mode Layouts	375	(1)
Script-Driven Finds	375	(1)
Data Presentation	376	(1)
Text Formatting	376	(1)
Auto-Formatting Data	376	(1)
Working with Table View	377	(1)
Troubleshooting	378	(1)
FileMaker Extra: User Interface Heuristics	379	(2)
Specialized Calculation Functions	381	(40)
What's a Specialized Function?	382	(1)
Logical Functions	382	(16)
The Let function	382	(2)
The Choose Function	384	(2)
The GetField Function	386	(3)
The Evaluate Function New	389	(6)
The Lookup Functions New	395	(3)
Text Formatting Functions	398	(5)
Text Color, Font, and Size	399	(1)
Text Style	399	(1)
Examples Involving Text Formatting Functions	400	(3)
Array Functions	403	(3)
Working with Return-Delimited Data Arrays New	404	(1)
Stepping Through an Array	405	(1)
The ``Filter''-ing Functions New	406	(3)
The Filter Function	406	(2)
The FilterValues Function	408	(1)
Custom Functions New	409	(9)
Uses of Custom Functions	409	(2)
Creating Custom Functions	411	(3)
Examples of Custom Functions	414	(4)
Troubleshooting	418	(1)
FileMaker Extra: Creating a Custom Function Library	419	(2)
Advanced Scripting	421	(24)
What Is Advanced Scripting?	422	(1)
Script Parameters New	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)
The Anatomy of a Window	430	(3)
Positioning a Window Relative to Another Window	433	(4)
Go to Related Record	437	(5)
GTRR Basics	437	(2)
Predicting the Found Set	439	(2)
Jumping to Disconnected Table Occurrences	441	(1)
Troubleshooting	442	(1)
FileMaker Extra: Recursive Scripts	443	(2)
Working with Portals	445	(30)
Portals in FileMaker Pro	446	(1)
Portal Basics	446	(6)
Portals Versus List View/Table View	447	(1)
New Portal Setup	448	(2)
Relationship Properties	450	(1)
Sticky Portals New	451	(1)
Scripted New Portal Records	452	(1)
``New Record Only'' Relationships	452	(2)
``Horizontal'' Portals	454	(1)
Selection Portals	454	(8)
Basic Selection Portals	455	(3)
Portal Row Highlights	458	(2)
Multi-keys and Multi-row Selections	460	(2)
Filtered Portals	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)
Dynamic Portal Sorting	468	(4)
Multiple Field Type Portal Sorting	470	(1)
Descending Dynamic Portal Sorting	471	(1)
Troubleshooting	472	(2)
FileMaker Extra: Portals and Record Locking New	474	(1)
Troubleshooting	475	(32)
What Is Troubleshooting?	476	(1)
Staying Out of Trouble	476	(8)
Understand Software Requirements	476	(1)
Avoid Unclear Code	477	(7)
Planning for Trouble	484	(1)
Troubleshooting Scripts and Calculations	485	(7)
Handling Errors in Scripts	486	(2)
Tracking Down Errors	488	(4)
Troubleshooting in Specific Areas: Performance, Context, Connectivity, and Globals	492	(11)
Performance	492	(3)
Connectivity and Related Issues	495	(3)
Context Dependencies	498	(4)
Globals New	502	(1)
File Maintenance and Recovery	503	(1)
File Maintenance	503	(1)
File Recovery	504	(1)
FileMaker Extra: Other Tools of the Trade	504	(3)
Converting Systems from Previous Versions of FileMaker Pro	507	(30)
Migration Choices	508	(5)
Factors Influencing Your Migration Strategy	508	(5)
The Bottom Line	513	(1)
Converting Files	513	(3)
Converting Single-File Solutions	514	(1)
Converting Relational Solutions	515	(1)
Pre-Conversion Tasks	516	(6)
Prepare for Conversion	516	(1)
Document Your Solution	517	(1)
Fix File References	518	(3)
Do Some Housekeeping	521	(1)
Post-Conversion Tasks	522	(9)
Security	522	(3)
Relationships	525	(1)
Scripts	526	(2)
Fields and Formulas	528	(3)
Troubleshooting	531	(1)
FileMaker Extra: Converting Web-Enabled Databases	532	(5)
Instant Web Publishing	532	(1)
Custom Web Publishing	532	(5)
IV Data Integration and Publishing
Importing Data into FileMaker Pro	537	(26)
Working with External Data	538	(1)
Flat-File Data Sources	538	(9)
Choosing the Target Table	538	(1)
Initiating the Import	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)
Importing Text Files	547	(2)
Importing Image Files	549	(2)
Importing Photos from a Digital Camera	551	(1)
Importing from an ODBC Data Source	552	(7)
How ODBC Works	553	(1)
Installing ODBC	554	(1)
Creating a DSN	555	(2)
Performing the ODBC Import	557	(2)
Importing from an XML Data Source	559	(1)
Using a Script to Import Data	559	(1)
Troubleshooting	560	(1)
FileMaker Extra: Exploiting the FileMaker-to-FileMaker Import	561	(2)
Duplicating a Found Set	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)
Exporting Field Contents	574	(1)
Exporting Grouped Data	574	(2)
Scripted Exports	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)
Troubleshooting	599	(1)
FilmMaker Extra: Installing and Troubleshooting the ODBC Client Driver	600	(5)
Instant Web Publishing	605	(34)
Instant Web Publishing--An Overview	606	(4)
What Is IWP?	606	(1)
IWP Improvements in FileMaker Pro 7 New	607	(1)
Scenarios for IWP	608	(1)
Getting Started with IWP	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)
Constraints of IWP	619	(1)
Scripting for IWP	620	(3)
Layout Design	623	(3)
Container Fields	626	(1)
Application Flow	627	(6)
Using an IWP Solution	633	(2)
Browse Mode	633	(1)
Edit Mode	634	(1)
Find Mode	634	(1)
Sorting Records	635	(1)
Troubleshooting	635	(1)
FileMaker Extra: Building Your Own Next and Previous Page Buttons	636	(3)
FileMaker and Web Services	639	(32)
About Web Services	640	(1)
FileMaker and XML	641	(5)
The Basics of XML	641	(1)
FileMaker's XML Grammars	642	(4)
Transforming XML	646	(7)
Introducing XSL Stylesheets	647	(2)
Analyzing a Stylesheet	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)
Web Services Reviewed	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)
Troubleshooting	666	(1)
FileMaker Extra: Write Your Own Web Services	667	(4)
Custom Web Publishing	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)
About Server-Side XSLT	692	(1)
Getting Started with XSLT in CWP	692	(1)
A Simple Stylesheet to Display Search Results	693	(2)
Format of the XSLT URL	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)
Other Query Commands	715	(1)
Other Query Parameters	716	(2)
About the FileMaker XSLT Extensions	718	(1)
About Sessions	719	(1)
Troubleshooting	720	(1)
FileMaker Extra: About the Custom Web Publishing Tools	721	(8)
The CDML Converter New	722	(1)
The Site Assistant	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)
Single User	730	(1)
Peer-to-Peer Hosting	731	(1)
FileMaker Server	731	(1)
Web Publishing	732	(1)
ODBC/JDBC	733	(1)
Citrix/Terminal Services	733	(1)
Runtime Solutions	734	(1)
Deploying to Handheld Devices	735	(2)
FileMaker Server	737	(40)
About FileMaker Server	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)
Running FileMaker Server	743	(1)
Starting and Stopping FileMaker Server	743	(1)
Hosting Databases	744	(1)
Using the Server Administration Tool	744	(2)
Configuring and Administering FileMaker Server Using the SAT	746	(2)
Server Administration Settings	746	(1)
Resource Usage Settings	747	(1)
Client Connectivity Settings	748	(1)
Managing Clients	748	(1)
Managing Databases	749	(1)
Administration from the Command Line	750	(4)
About System Paths	750	(1)
Command Line Reference	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)
Preparing FileMaker Pro	762	(1)
Performing the Auto Update	763	(4)
Putting It All Together	767	(1)
Scheduled Tasks	768	(3)
Scheduling Backups	769	(1)
Running Scripts	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)
Troubleshooting	774	(1)
FileMaker Extra: Best Practices Checklist	774	(3)
Determine Network Infrastructure	775	(1)
Purchase Hardware	775	(1)
Install Software	775	(1)
Configure FileMaker Server	775	(1)
Deploy Databases and Schedule Backups	776	(1)
Monitor Usage Statistics	776	(1)
Monitor Event Logs	776	(1)
Perform Regular File Maintenance	776	(1)
Keep Current with Software Updates	776	(1)
FileMaker Developer and Plug-ins	777	(256)
FileMaker Developer	778	(11)
Script Debugger	778	(2)
Database Design Report	780	(1)
Developer Utilities	781	(8)
Custom Functions	789	(1)
File Maintenance	789	(1)
Plug-ins	789	(4)
Understanding Plug-ins	790	(1)
Using FileMaker's Sample Plug-in	791	(1)
Installing Plug-ins	791	(1)
Deploying Plug-ins via FileMaker Server	791	(1)
Configuring and Enabling Plug-ins	792	(1)
Troubleshooting	793	(1)
FileMaker Extra: The Limits of Customization	794	(5)
Lack of Multi-user Capability	794	(1)
Lack of Menu Customization	794	(1)
Lack of Event Triggers	795	(4)
VI Appendixes
A Additional Resources	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)
FileMaker News Sources	802	(1)
Plug-ins	802	(2)
Developer Tools	804	(1)
Web Programming	805	(1)
XML/XSL	805	(1)
ODBC/JDBC	806	(1)
B Calculation Function Reference	807	(120)
C Script Step Reference	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)
Scripts	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)
Creating a DDR	1027	(1)
Working with the DDR in HTML	1028	(1)
Using the XML version	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

Excerpts

= 0) {slash = '\\';} else {slash = '/';}openLoc = figLoc.substring(0, figLoc.lastIndexOf(slash) + 1);while (pPage.substring(0,3) == '../') {openLoc = openLoc.substring(0, openLoc.lastIndexOf(slash, openLoc.length - 2)+ 1);pPage = pPage.substring(3, pPage.length + 1);}popUpWin =window.open('','popWin','resizable=1,scrollbars=1,location=0,toolbar=0,width=525,height=394');figDoc = popUpWin.document;zhtm= ' ' + pPage + ' ';zhtm += ' ';zhtm += ' ';zhtm += ' ';zhtm += '' + pPage.substring(pPage.lastIndexOf('/') + 1, pPage.length) + '';zhtm += ' ';figDoc.write(zhtm);figDoc.close();}// modified 3.1.99 RWE v4.1 --> INTRODUCTION INTRODUCTION Welcome to FileMaker Pro 7In this introduction Waiter, There's a Software Development Tool in My Productivity Application! How This Book Is Organized A Brave, New World Waiter, There's a Software Development Tool in My Productivity Application!Welcome to the world of FileMaker Pro. By simply standing in this section of your local bookstore, you're sure to have heard the word "database." We'll cover what databases are ad nauseam in the rest of this book--so go ahead and take it up to the counter...we'll wait--but one of the first things you'll need to understand about FileMaker Pro is that it is far more than just a database.FileMaker Pro is nearly unique in the world of software. It is a powerful database system that can manage and store a wide range of information; it's an application for end users (like Microsoft Excel or Intuit's Quicken), and it's also a robust rapid application software development platform.When you hear someone speak about FileMaker, keep in mind they may be viewing it from one of these different perspectives or another. An IT professional likely sees it as a database engine that fits into a greater security and network infrastructure. An end-user probably is thinking about a specific solution built in FileMaker Pro and how that solution helps (or doesn't help) make work more efficient. A software developer may see it as one of many tools he employs in building a wide range of applications.However you approach FileMaker Pro, some core strengths of the platform are important to all types of users.Flexibility--Working with FileMaker Pro is inherently open-ended. It is simple to create ad hoc data queries, quickly manage data entry, add functionality to a live system, or deploy to the Web in minutes.Ease of Use--The folks at FileMaker, Inc., have labored hard to make FileMaker as approachable as huma