This manual has everything I ever needed to know about Filemaker in it. Easy to understand and a great tool for those who are new to Filemaker (as well as people who aren't so new, but don't know it all).

This manual has everything I ever needed to know about Filemaker in it. Easy to understand and a great tool for those who are new to Filemaker (as well as people who aren't so new, but don't know it all).

I was disappointed by this book, especially considering the high reviews that it has received. I would consider myself an advanced computer user and intermediate in working with programs like FileMaker. (Though database programs I have used before have had less features). This book uses an example of building a database throughout the book that involves customers and invoices, etc. The problem is that in later chapters the ongoing example database begins to interfere with the presentation of the material. If you have the time to work through the example database in detail (for a few hundred pages+) you might have a decent understanding of Filemaker-at least within the context of the example. Or if you have that kind of time, you might just want to take a class. I started with the beginning of the book when I began to build my database (which does not involve customers and invoices). After doing the initial planning/building work, I tried to skip to other parts of the book that were relevent to what I needed to do. Unfortunately, most of the descriptions are based on the original example--this made it difficult to apply the information to my own project. If the functions had been just described clearly at the beginning of each section, without relying on the example it would have been much better. There are a few mistakes as well-small but they cost me a bit of time. E.g., the book states that the "missing fields" problem can be fixed by changing a setting in preferences. This is not necessarily right--in my case it turned out to be a layout issue. I've had better results with trial and error than on relying on most of the book. Also, the language is not as clear as it could be, and precision is important in a book like this, especially for those of us who are not advanced users. Most importantly, I would have preferred a book with more straightforward descriptions and instructions.

I have been trying to use all the resources - bundled manuals, vtc, lynda.com since 2005 to learn filemaker/a database from scratch. I chose filemaker for 2 reasons - ease of use and support for OS X technologies like Applescript. I found it a bit challenging to understand concepts in Database design but with this one book things were more clear than ever before. I have finished this book and am planning to buy the latest version for filemaker 9.

If you are a newbie in database programming and need to get a well explained book to help you through building your own database. Get this book. It is well worth it.

BTW thanks for this book, I have a fully functional database to manage information related to my studies and research.

Why software cannot come with good manuals anymore is a mystery. This is exactly as advertised, the missing manual. Some other books will show you how to build bigger, more sophisticated solutions, but this one covers every aspect of how Filemaker works, which is what a manual should do.

Oh, and by the way, Filemaker is an amazing, underappreciated tool which helps manage a mailing list or build an entire database system. You cannot go wrong with it.

I hesitate to write negative reviews because I always suspect that the errors I find are my own misunderstandings. In this case I felt COMPELLED to write one. I bought this book wanting it to be great and having high expectations based on the reviews I read. I doubt many of the reviewers OR the EDITORS read this book very closely. There are so many mistakes (small and large) and examples which flat out DON'T WORK, that the book has almost driven me mad. I've wasted HOURS trying to get things to work the way the authors described. The errata posted on the oreilly.com site lists maybe 1/4 of the errors. There is ONE posted review on Amazon.com which took notice of this, but all of the others seem to miss it completely. Kudos to Raymond Smith!

Two perfect examples (in case you want to save yourself a few hours of struggle):

1. The Invoice Finder tutorial on page 372 simply doesn't work using the "minimum amount" field as they describe. It will work using the date range criterion, but when you add the minimum amount match, it fails. I built a file following along with the text and thought it was MY file that was broken. Then I tried the files supplied with the Missing Manual "CD". The authors' files don't work either. They SEEM to work with the data already in them, but if you add an invoice, it doesn't work. And if you simply open the "options..." definition of the Total Due field on the "Invoices" table, then OK the dialog box, all the existing data fails as well. It must be some kind of indexing problem, but the fact that it slipped by the editors is almost impossible to believe.

2. The Repeating Fields for Multiple Results on page 417 is totally wrong. The formula they supply will not work at all, and in fact, unless the "Price" field is a repeating field as well (which they don't mention at all), you can't do any calculations using the "Get(CalculationRepetitionNumber)" that will work the way they describe. Not to mention the fact that in the second mention of the calculation they call it "Get(CalculatedRepetitionNumber)" which is wrong and won't even take. The text suggests that you "test this calculation with a few numbers", but I doubt that any editor tried it. AND THIS IS LISTED IN A POWER USERS' CLINIC.

I don't know if this is an author problem or an editor problem, but either way, it is a REAL problem for readers.

What a disappointment and a waste of many hours... Don't listen to the majority of reviews on this book. They have clearly come from people who read it but were not actually trying to learn from the DOING the examples in the text. The book is written in a friendly easy style, but there are too many errors to make it valuable. And it's been out for TOO long for these things not to be listed in an available errata or supplement.

I'm not a database expert, yet I'm not a beginner. This review is from a person with a basic understanding of database programs.

I'm about halfway through this book and it has been a great guide to learning about FileMaker. However, it is soooo frustrating that there are many errors in the examples used throughout the book. With all the dry, technical speech (the author does try to lighten it up some) my ADD may kick in a little causing me to read it wrong while thinking about something else, but there are many times when the book tells me to do something with the example file you download with the "missing cd" and it just doesn't working right. For me it doesn't matter if they have updates on misprints in the book available online. I'm the kind of person who would prefer it be printed correctly the first time and not have to check everything against an online list of typos. That said, and taking the examples with a grain of salt and just getting the concepts behind them, I really do think this book is a good resource for becoming familiar FileMaker pretty fast. I've not read any other books but this one has to be one of the most comprehensive ones.

Without this book, it will take a long time to understand how the program really works. Unfortunately the manufacturer's provided help is too filled with "jargon" and not enough explanation. It becomes necessary to "reverse engineer" the provided examples to understand how much of the program can be used, being time consuming and filled with trial and error. And since there is no printed version, there is no where to put the notes and comments always gathered as one learns a program

Having written software on a professional basis for the original PCs in assembly language and being a regular user of such systems as SolidWorks parametric software I have a proven ability to understand. But the documentation that came with FileMaker was insufficient to grasp too may details needed to make the program usable in creating one's own databases rather than use a "canned" template.

The book is well written and gives good examples. In addition the authors are available by email to help really serious problems, but don't abuse that by constant pestering. I doubt if I could have gotten good use of the program in any reasonable time without this book. I only gave it a 4 instead of a 5 because I think it could be made perfect with a few more actual written examples of the scripts or commands as the user would type or use them in the program. My real rating is 4.5 But that doesn't detract from it's value. Having looked at other books I feel this is the best.

Bob McCormack
Sonoma, CA

This is what a technical manual should be. Well written in a style that avoids jargon. Well organized so that it covers every major point of the application, without endless excuses that certain subjects are beyond the scope of the book. Carefully indexed. Well edited. Profusely and intelligently illustrated. And, finally, designed for readability.

FileMaker beginners will find that this is a true tutorial and covers far more territory than most casual users will want to travel. FileMaker pros will find this a handy reference for the inevitable moment when they can't remember something or need to explore a function new to them.

This edition has been outmoded to a degree because of the introduction of FileMaker 8.5, but it is still eminently useful.

In short, this truly is the "missing manual" for FileMaker Pro 8 and should be considered an essential book for any user. It is far superior to "Special Edition Using FileMaker 8".

Jerry

As the title, and most of the reviews (save Mr. Strauchs') suggest, this is the manual that doesn't exist in print. It's a nice alternative to the Help menu as it's written in a personable style that offers more direct and real-world applications for the basics of FileMaker.

However, as someone who has developed in FileMaker since version 2, I was hoping for a bundle of "tips'n'tricks" that were updated for FMP 7 & 8. But there's not even a simple explanation for a self-relation to find duplicate records (there is on the FileMaker site, but it's not documented in the TOC for Help; and it's more or less unchanged from the version 6 documentation). I'm wondering, with all the new features and new structure of FMP included in versions 7 & 8, how much is really new? It's nice to know that all the familiar tools are there to create field, layouts, and scripts, but I was hoping that the FileMaker redesign might save me a bit of time and make my scripts and calculations a bit more lean. But you won't find that here.

[I empathize with Mr. Strauchs, as I've had similar experiences with MS database products. But, at least superficially, he must have missed a Help menu item in FileMaker about importing Excel files. This may be covered in the book, but, alas, the index is of no help, and importing (or even opening Excel files from FileMaker as on page 630 of the book) is a basic operation not adequately cross-referenced, and a topic that many new users and cross-platforms users would love to know about].

My overall impression is that this is a hasty rehash of FileMaker (FMP) updated for the current version. It lacks a depth of organization and example that would make it an exemplary guide, but it covers every damn bit of the basics completely and, sometimes, without much real imagination.

Concur with all the other reviewers that this is THE best, most complete, yet easy-to-follow guide to FileMaker Pro [FMP]. The authors really have gone out of their way in using plain words to describe arcane concepts, and the illustrations are well executed. Although there are the usual typos and occasional ambiguous/misleading statements, there is a continuously updated website with 'Errata' and sample completed tutorial exercises. [If these were included on a CD with the book, this book would warrant a super-nova rating!]

A stellar guide that's easy to understand; as the title so aptly implies -- this manual should have been included with the expensive FMP software.

Are you a programmer that has been working with FileMaker for a while? If you are, then this book is for you! Authors Geoff Coffey and Susan Prosser, have done an outstanding job of writing a book that explores each feature in depth, offers shortcuts and workarounds, and explains the ramifications of options that a FileMaker Pro manual doesn't even mention.

Coffey and Prosser, begin by exploring FileMaker Pro's interface; and, show you how to perform basic tasks, like entering data and then sorting through it again. Then, the authors show you how to use layouts to make data entry easier and how to create layouts that list and summarize your data. They continue by showing you how to create, connect, and manage multiple tables and how to set up complex relationships that show you just the data you need to see. Next, the authors show you how to use FileMaker Pro's 200+ functions to do the math for you. Then, they show you how scripting works, and learn how to make scripts for people to use. Finally, the authors show you how to protect your database with a password and how to use privileges to determine what folks can do once they get into your database.

FileMaker Pro comes in several flavors, and this excellent book addresses them all. Each chapter contains live examples--step-by-step tutorials that help you learn how to build a database by actually doing it!

I have developed many database applications in other software programs. FileMaker is quite different from the rest, so I had to learn "by the book" to understand many of Filemaker's unique features, so I purchased Filemaker Pro 7 Bible and Using Filemaker Pro 7. The Bible book was totally useless, giving you details for beginners and lots of useless text for someone who already understands database development. The Using books gives details, both not a straight forward approach to developing a database.
But once FileMaker Pro 8: The Missing Manual came out (the first to cover version 8), I purchased it. To my surprise, it was so well written and loaded with practical advise, that I have read to book from end to end. It has excellent examples that I have used in the application I am developing for my company. I continually go back to the book for refreshers to concepts I learned in the book. The other two books hardly get touched!
If there is one book to buy to learn FileMaker Pro, this is it!

Touted as the "missing manual" I was expecting good guidance on concrete applications. I bought the software with the primary intent of converting various large Excel files into a database. The manual is large on theory and small on concrete help. My efforts to convert Excel files failed so often that I finally gave up trying. The book was of no help.

Geoff Coffey and Susan Prosser's FILEMAKER PRO 8: THE MISSING MANUAL covers everything from database creation and using templates to streamline FileMaker efforts to considering the program's layout tools, calculation formulas, and translating databases for the Web. From beginner to advanced topics, FILEMAKER PRO 8 covers it all using easy language, black and white screen shot examples on almost every page, and plenty of modeling examples.

I found this manual to be easy to use and understand. Easy to follow with wonderful illustrations and examples. Walks you through each feature and begins with a basic explanation of relational database theory. Uses a systematic design approach, building on each foundational design process while incorporating functions and features. The extra tips along the way are very useful. Light and humorous at times, making it enjoyable reading. Thorough step-by-step processes. If you are a seasoned FMP programmer, this makes a great reference for new features found in version 8 but lacking in coverage of all features. It was void of giving definitions to all of the new functions and operators introduced in version 8. It is also weak on publishing via a FMP server via the web. Only gave an introduction. I had to go to FMP to get PDF documents on specifics for publishing via server on the web. However, with respect to the authors, this book was not intended to cover that kind of detail and they disclaimed that up front.

Very good - somehow this book manages to cover the basics and get to the more complex aspects in clear understandable terms. I'm sure for the power user there's stuff missing but for a mid skill user who (for example) wants to use portals effectively it's very clear.

I've been using Filemaker since it was originally developed by Claris (or was it Apple?); I currently am using Filemaker Pro 7.0 v3 on my Apple computers. I obtained "The Missing Manual for Filemaker Pro 8" to evaluate those features that are "new" to FP 8 or a significant improvement over an existing FP 7 capability. This evaluation of new benefits would justify the expense of purchasing an upgrade to Filemaker Pro 8.
The Introduction section does provide a succinct summary of the new features of FP 8. I've read the book as a reference and training manual.
"The Missing Manual for Filemaker Pro 8" is a comprehensive and detailed document that is replete with descriptive words, well chosen illustrations AND builds upon a comprehensive set of sample database files available from the www.missingmanuals.com web site. These sample files greatly ease the task of learning the features of Filemaker Pro. Like all Missing Manual books, the web site provides valuable errata in addition to the working examples.
This is a valuable reference (and now a well thumbed resource) whether you are new to Filemaker Pro, an experienced database developer or a "professional" database designer.

For anyone that uses FileMaker Pro on a daily basis, this book is an absolute steal. With over 700 pages of relevant information, the authors go beyond this applications basic use as digital address book and really get into the details of what makes this a great application. With tons of pictures and clear detail how to follow along, the authors start with the basic use of displaying and inputting people data and go far beyond that, discussing design of databases and learning how to script FileMaker Pro to get this program to do nearly anything you need it to! Reports, exporting data to other formats, or publishing to the web, this book has it all!

A must read for any FileMaker Pro user who wants to get the most out of their experience and learn the ins and outs.

***** RECOMMENDED

This is definitely a must have book for FileMaker users. Not only does it have in depth coverage of all of the front-facing features. It also has an excellent theory section on database design which is really critical regardless of what database technology you use. It's tough to find a solid practical theory lesson on database design in any book and this walkthrough is great. If for that section alone this book is worth the money.

FileMaker Pro is essentially a very nice front end to a relational database. Aimed at people like you who might not have a strong background in SQL or database theory, but who do need to commit information to a database.

As with other books in the Missing Manual series, the tone is lighthearted. But it does not entirely conceal the fact that FileMaker is still nontrivial to learn. Despite the huge efforts put into the program by its developers, the database issues cannot all be finessed. Though, granted, if you have only one table, then no matter how many columns or rows, FileMaker Pro should be well adequate. More realistically, once you have several interrelated tables, some of you should seriously consider going whole hog and learning a full SQL approach.