FileMaker Pro Design and Scripting For Dummies

by Timothy Trimble

Overview

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

Product Details

ISBN-13:	9780471786481
Publisher:	Wiley
Publication date:	07/12/2006
Series:	For Dummies Books
Pages:	384
Product dimensions:	7.30(w) x 9.20(h) x 0.90(d)

About the Author

Timothy Trimble is a professional computer geek, writer, and software developer with over 25 years of industry experience. He started as a video game developer and worked his way into the PC and PDA software development markets on various commercial, corporate, and vertical market applications.
He currently exhibits his geekish tendencies as a FileMaker developer at SolutionMakers, Inc. (www.solutionmakers.com) in Woodinville, WA. Timothy has written a multitude of articles for various industry publications and wrote a book on flight simulation. He maintains a blog on the Art of Software Development at www.timothytrimble.info. Although he has significant publishing credits in the computer industry, he dreams of some day having his science fiction work published as well.
When Timothy is not cranking away at the keyboard, he likes to be with his family, entertain his friends by singing and playing guitar, and door-to-door to tell others about his faith. Feel free to contact Timothy with your comments on this book by e-mailing him at [e-mail].

Read an Excerpt

Click to read or download

Table of Contents

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

Editorial Reviews

...the contribution of this book lies above all in the compelling argument that the political and military history of the 30s BC is more important for an understanding of all three of Virgil s major works than it is often taken to be... Powell s Virgil is unashamedly pro-Octavian, pro-Augustus... This is not a fashionable approach to Virgil, and doubtless many will resist Powell s political reading. But it will be impossible in future to ignore Powell s careful and detailed arguments for the centrality of the historical context... --Philip Hardie and Julia Dyson Hejduk "Vergilian Society Prize Committee citation "

Powell is not afraid to use modern parallels that, among other things, demonstrate clearly to a contemporary audience how knowledge of the timing of an event can inform our understanding of it and of a writers reasons to include or exclude it. He writes in a lucid and attractive style, displaying his admiration for Virgil on every page...'--D.E. Hill"Greece and Rome" (01/01/2009)

Powell s analysis is acute and his reading is coherent and cogent. This is a book full of interest and surprises on virtually every page... --John Godwin "Journal of Classics Teaching "

Radicalises the study of politics in Augustan poetry...A book rich in arguments which opens new fields to explore.'--Frank Wittchow "Gymnasium "

This stimulating volume seeks to put the party politics back into Virgils oeuvre...Powell rightly concludes that the success of the Augustan project has concealed the partisan and prophetic aspect of Virgils political stance...'--Stephen Harrison "Mnemosyne "

Toward the end of this book, Powell (Univ. of Wales) sums up his approach as proceeding from ideals expressed to realities suffered.' A striking example of this is the chapter titled 'The Theft of Pietas, ' in which the author argues that Virgil, unable to credit Octavian with "pietas", creates the image of a "pius" ancestor, Aeneas, the incarnation of this virtue, which would then be transferred by association to Octavian. Powell himself is much more partial toward Sextus Pompeius--witness "Sextus Pompeius", which he edited with Kathryn Welch (2002)--a fierce opponent of Octavian who styled himself Magnus Pius. One of Powells objectives here is to shift the focus of Virgilian studies from individual works to the whole oeuvre and to see one intention in all of them, to defend the cause of Octavian-Augustus. Although he accepts the premises behind analyses of Virgils works based on genre and architecture, Powell sees an overarching political structure. In elaborating this thesis he makes good use of neglected ancient historians of the period--Suetonius, Appian, Dio Cassius. His countercurrent argument is bound to stir up much controversy among traditional Virgilian scholars, which is all to the good. An absorbing read. Summing Up: Highly recommended. Upper-division undergraduate through faculty.--C. Fantazzi, East Carolina University"Choice" (01/01/0001)

From the Publisher

‘Powell's analysis is acute and his reading is coherent and cogent. This is a book full of interest and surprises on virtually every page...’

Journal of Classics Teaching - John Godwin

‘...the contribution of this book lies above all in the compelling argument that the political and military history of the 30s BC is more important for an understanding of all three of Virgil's major works than it is often taken to be... Powell's Virgil is unashamedly pro-Octavian, pro-Augustus... This is not a fashionable approach to Virgil, and doubtless many will resist Powell's political reading. But it will be impossible in future to ignore Powell's careful and detailed arguments for the centrality of the historical context...’

Vergilian Society Prize Committee citation - Philip Hardie and Julia Dyson Hejduk

This stimulating volume seeks to put the party politics back into Virgils oeuvre...Powell rightly concludes that the success of the Augustan project has concealed the partisan and prophetic aspect of Virgils political stance...'

Mnemosyne - Stephen Harrison

Radicalises the study of politics in Augustan poetry...A book rich in arguments which opens new fields to explore.'

Gymnasium - Frank Wittchow

Powell is not afraid to use modern parallels that, among other things, demonstrate clearly to a contemporary audience how knowledge of the timing of an event can inform our understanding of it and of a writers’ reasons to include or exclude it. He writes in a lucid and attractive style, displaying his admiration for Virgil on every page...'

Greece and Rome - D.E. Hill

Toward the end of this book, Powell (Univ. of Wales) sums up his approach as proceeding from ideals expressed to realities suffered.' A striking example of this is the chapter titled 'The Theft of Pietas,' in which the author argues that Virgil, unable to credit Octavian with pietas, creates the image of a pius ancestor, Aeneas, the incarnation of this virtue, which would then be transferred by association to Octavian. Powell himself is much more partial toward Sextus Pompeius—witness Sextus Pompeius, which he edited with Kathryn Welch (2002)—a fierce opponent of Octavian who styled himself Magnus Pius. One of Powells objectives here is to shift the focus of Virgilian studies from individual works to the whole oeuvre and to see one intention in all of them, to defend the cause of Octavian-Augustus. Although he accepts the premises behind analyses of Virgils works based on genre and architecture, Powell sees an overarching political structure. In elaborating this thesis he makes good use of neglected ancient historians of the period—Suetonius, Appian, Dio Cassius. His countercurrent argument is bound to stir up much controversy among traditional Virgilian scholars, which is all to the good. An absorbing read. Summing Up: Highly recommended. Upper-division undergraduate through faculty.

Choice - C. Fantazzi