You use FileMaker every day--you know your way around the basics. But howcan you be sure you're getting the most out of this database heavyweight?Take your skills to the next level with FileMaker Pro 5/5.5 Pro Advancedfor Windows and Macintosh: Visual QuickPro Guide, the quickest, easiestway to put FileMaker's power to work for you.
FileMaker Pro 5/5.5 Advanced: VQP doesn't waste your time withwordy explanations. This visual, task-based guide is loaded withscreenshots and clear, concise explanations of key database publishingtechniques, including working with records and files, designing databases,printing and networking, Web publishing, and more. The book covers topicsyou can put to immediate use, whether you have version 5 or version 5.5:data reports and relationships, conditional script steps, scripttroubleshooting, FileMaker and third-party software, and security issuesraised by multiuser files.
1. About FileMaker Pro 5.0.
FileMaker 5.0: Highlights of New Features. FileMaker 5.0 Editions. About Upgrading to FileMaker 5.0. Using This Book.
About Relational Databases. Gathering Information. Creating a Field List. Developing a Data Structure Strategy. Creating a Data Structure Chart. Field Design Tactics. Implementing Relationships. Testing Your Database.
Usability, Legibility, and Logical Grouping. Cross-Platform Issues. Using Graphic Text. Formatting Elements as Buttons. Reusing Graphics. Entering Data in a Standard Layout. Creating and Formatting Value Lists. Validating Formats with Value Lists. Working with Conditional Value Lists. Using Calculated Field Labels. Creating Field Masks. Copying Layouts.
Merging Fields Using Calculations. Formatting Labels or Envelopes. Formatting Form Letter Modules. Augmenting a Form Letter.
Using Search Operators. Creating an “Inverted” Search. Creating Summary Layout Parts. Using Counts and Averages. Creating Running Totals. Creating Sub-summary Reports. Sorting Data for Sub-summary Reports. Exporting Summary Data.
About Relationships. Creating a Match Field in a Master File. Lookup vs. Related Fields. Using a Match Field to Choose a Related Record. Using Calculated Match Fields. Field Formatting with a Calculated Match Field. About Repeating vs. Related Fields. About Portals. Sorting Data in Portals. Summarizing Related Data. About Self-Relationships. Using a Portal for Navigation. Searching for Self-Relationship Data. Creating a Lookup with a Self-Relationship.
Planning a Simple Script. Storing Settings Before Scripting. Using ScriptMaker. Creating a Basic Script. Creating Sub-scripts. Combining Sub-scripts. Retaining Multiple Settings in a Script. Using Sub-scripts for Multiple Export Settings. Adding Comments to a Script. Using External Scripts.
About Conditional Steps. Using the If Command. Using If with Else. About Status Functions. Using Status Functions with If Steps. Using Loop in a Script. Using Counters to Control Loops. Controlling Scripts with User Input. Customizing Documents with If Steps.
Making a Find Layout with a Script. Creating Script Buttons. Deleting Records in a Related File. Creating a Main Menu Layout. Linking to the Main Menu. Running Scripts from Fields. Creating Interactive Error Messages.
Testing Finished Scripts. Fixing Typical Errors. Creating an Error Trap Script. Debugging Scripts. Printing Scripts. Changing and Adapting Scripts.
Using Scripts to Send Email. Using Scripts to Send Bulk Email. Using a Script to Open URLs. Exporting Data to Static HTML Tables. Exporting Formatted Text. Using Excel Data in FileMaker. Working with ODBC. Sharing Databases Using ODBC. Using AppleScript with FileMaker Scripting.
Migrating to FileMaker 5.0. Importing Data from Other Sources. Cleaning Up Text Data Before Importing. Finding and Eliminating Duplicates. Importing Data without Duplications. Troubleshooting Problem Data. Replacing Inconsistent Formatting. Separating Parts of Data.
Setting Network Protocols. Setting Up Multi-User Files. Hiding Related Files. Creating an Opening Script. Accessing Databases Over the Internet. Testing Scripts for Access Problems.
Hosting Files on FileMaker Server. Optimizing Server Settings. Setting Up a Usage Log. Managing Server Remotely.
Instant Web Publishing. Configuring Databases for Web Access. Choosing a Layout Style. Tracking Activity and Access. Accessing a File with a Browser. Enabling Remote Administration. Restricting Database Access. Creating a Custom Home Page. Creating a Guest Book. Testing Your Web Database. About Custom Web Publishing. Setting Up Custom Web Publishing. Creating a Template Format File. Prompting User Input with CDML. Providing Visitor Feedback. Searching for Data with CDML. Editing Data with CDML. Browsing Records. Using the Web Security Database. XML and JDBC. FM Developer's Edition.
FileMaker Pro 5.5: Highlights of New Features. FileMaker Pro Server 5.5: Highlights of New Features. FileMaker DE 5.5: Highlights of New Features.
Validating by Number of Characters. Using GetField. Updating Auto-Entry Serial Numbers. Disabling Toolbars. Creating Interactive Buttons. Restricting Access Privileges. Changing Password Access.
Import from Excel Ranges. About Improved Script Importing. Importing with Scripts. Setting the Next Auto-Entry Serial Number. Using Relative Paths. Using FileMaker Mobile. About FM5.5's ODBC Functions. Storing SQL Commands in Fields. Using Calculations to Build Complex Queries. Creating Dynamic SQL Queries.
Suppressing Built-In Navigation in IWP. Creating Web Layouts. Creating a Web-Based Find Script. Switching Layouts with a Script. Web Display Considerations.