FileMaker Pro 9:  The Missing Manual
by Geoff Coffey, Susan Prosser

The unconfirmed error reports are from readers.  They have not yet been 
approved or disproved by the author or editor and represent solely the
opinion of the reader.

Here's a key to the markup:
        [page-number]: serious technical mistake
        {page-number}: minor technical mistake
        <page-number>: important language/formatting problem
        (page-number): language change or minor formatting problem
        ?page-number?: reader question or request for clarification

This page was updated April 16, 2008.


UNCONFIRMED  errors and comments from readers: 

{no page} Contact Management File on the Missing Manual CD for Filemaker Pro 9;
The contact management example file has the sample record names in reverse order. Last Name field has the 
first name in it and the First Name field has the last name in it. Odd when you're entering Sanders in 
the Last Name field from the book to perform a find

[47] Last paragraph. ;
There are no 'Smith' records, nor are there 678 records in the practice file!!!

[321] FIgure 7-12;
Relationship logic is reversed in the text for this figure.

The paragraph states that the correct way to set up this relationship would be to have the primary key in 
the Line Items Table and the foreign key in the Invoices Table.

This is refuted in your own text:
page 310 (figure 7-7) crows feet on Line Item.
ditto for page 313 (figure 7-8)

In fact all fugures show a crows feet on Line Item, indicating a one to many relationship for Invoices to 
Line Items.

Page 319, bottom paragraph - Invoice Number is the primary key and becomes the foreign key in the Line 
Items table.

Page 320, bottom paragraph - "When you see a crow's foot on your ER diagram, you need a foreign key in 
the table to which it's attached."

Page 321, Note under figure 7-12 - repeats above rule. (322) 3rd paragraph;
Text I believe to be in error:

Likewise, one order can connect to many join records

I believe it should be:

Likewise, one payment can connect to many join records


(330) 4th line under figure 7-20;
The instruction reads: "Drag Invoice Payments::Invoice ID to Invoice ID"

This seems to be incomplete. Should it be "Drag Invoice Payments::Invoice ID to Table_____::Invoice ID??"

Or, should it be "Drag Invoice Payments::Invoice ID to Invoice ID::________Field"?

It seems like either a Table name or a Field name is missing from this instruction. 


(343) 3rd paragraph;
Text in my printing of the book (10/07)

The Customers table has to a to-many relationship to Jobs, so

I believe you are missing the correct relationship name here.

[347] Last paragraph in "Portal Power" box;
Text I believe to be in error:

Here's the trick: if anying in the portal is anchored


I don't understand what anying is supposed to be.

(595) Figure 15-21;
There are 2 Set Variable script steps. Shouldn't the second Set Variable script step read as follows:
Set Variable [$unbilledItems; Value:$unbilledItems + Get(FoundCount)]