FileMaker Pro Design and Scripting For Dummies

Get the scoop on designing databases for Mac and Windows Use FileMaker Pro design and scripting to quickly, easily build databases that solve real problems FileMaker Pro has grown up, and it's better than ever! This easy-to-use guide shows you how to design a great FileMaker application, build a database that works, add the functionality you need, populate your database, and venture into programming with ScriptMaker. You'll find out how to share and protect your database, too. Discover how to * Build a layout that works * Create custom triggers and calculated fields * Generate reports automatically * Manage security * Publish your database on the Web * Embed pictures, sound, and video

Introduction 1 Part I: Getting to Know FileMaker Pro 7 Chapter 1: Introducing FileMaker Pro 9 Chapter 2: Creating a Database 29 Chapter 3: Calculation Programming: You Have the Power! 55 Part II: Building the Perfect Beast 77 Chapter 4: Designing a Good FileMaker Application 79 Chapter 5: Whipping the Layout into Shape 105 Chapter 6: Finding and Sorting Your Data 125 Chapter 7: Making FileMaker Do Tricks 139 Part III: Taking Control with FileMaker Programming 155 Chapter 8: It’s All in the Script! 157 Chapter 9: Your Programming Toolbox 179 Part IV: FileMaker Exposed! Sharing and Protecting Your Database 193 Chapter 10: Share (Data) and Share Alike 195 Chapter 11: Batten Down the Hatches! Keeping Your Data Safe 227  Chapter 12: Putting Your Databases on the Web 241 Part V: The Part of Tens 255 Chapter 13: Ten Cool Things You Can Do with FileMaker 257 Chapter 14: Ten (Or So) Items to Aid Your FileMaker Development 275 Appendix: Scripting Reference 281 Index 343