Errata

Figure 1-10 shows 14th (= last) record of the found set. Caption says: seventh.

Note from the Author or Editor:
Caption should indicate that "You're looking at the 14th record...."

The shortcuts for next and previous record show as using the "Command" key on the Mac. In fact they use the "Ctrl" key.

Note from the Author or Editor:
in both paras the text reads "press Ctrl (CMD)-"

they should both read: "press Ctrl +"

The names in the figure are supposed to be sorted by Last Name and then First Name. But, Niki Sanders comes before Micah Sanders.

Note from the Author or Editor:
Screen shot is wrong. It will be re-taken for the next edition.

Figure 2.2 shows and describes how values in the Status field change to question marks when the column is too narrow to hold the data. This does not happen in my version of Filemaker Pro (10.0v on Mac). When the column is too narrow, the data in the field is simply truncated and not shown as a question mark.

Note from the Author or Editor:
Edit the first part of the caption for Figure 2-2 to read:

"This is the same database and active record shown in Figure 2-1, but this layout is in Table view. The Status field is formatted as a pop-up menu (page 245), but is too narrow for the data to show, so you see question marks, and the mouse ..."

The OR should read AND in the two sentences.

Note from the Author or Editor:
reader is correct

Searching for "New York" returns no found records because in the sample chapter 2 file, each instance is misspelled "New Yorq"

Note from the Author or Editor:
Should be:

1. Switch to Find mode and, in the City field, type "New" and then click the Perform Find button.

You don't have to type the whole entry you're looking for, just enough of it to separate it from other entries. FileMaker shows you a found set of all your New York records.

Going to url specified, "http://missingmanuals.com/screencasts." returns error -

"Forbidden
You don't have permission to access /screencasts/ on this server."

Selecting "Screencasts" from menu down the left side of the web page shows several different books, but none for FileMaker 10. Only FileMaker book is Pro 9, and for that book there is no screencast regarding text formatting.

Note from the Author or Editor:


The link should be http://missingmanuals.com/screencasts.html

Unable to choose Format-->Text when no text is selected. Format-->Text is greyed out when no text is selected.

Note from the Author or Editor:
Should be:

"...To avoid unintentional formatting, make sure that when you choose Format -> Text, you're just clicked in a field, but you don't have any text selected."

Top of page cheat sheet second bullet point says:
Drag Invoices::Job ID to Jobs::Job ID

Fig 7_20 shows a relationship line from Invoices Table Job ID diagonally to the third table on the top row being the Expenses Table (and within that the Job ID).

Should that very line go to the second table in the top row being the Jobs Table (and within that the Job ID) to match the cheat sheet instructions which seem logical and correct?

Can be confusing for a beginner.

Thanks

Note from the Author or Editor:
The relationship line between Invoices and Expenses should actually be between Invoices and Jobs.

The mistaken reversal of call-outs 2 and 3 in Figure 7-23 (already mentioned in the errata) is repeated in Figure 8-3.

Note from the Author or Editor:
The callouts for "Duplicate selected items" and "Create or edit relationship" are reversed in Figure 7-23 and Figure 8-3.

The Greater-Than-or-Equal-To and Less-Than-or-Equal-To operators as displayed in the code example got mixed up. It should be the other way around.

Note from the Author or Editor:
In the paragraph after the code example on page 388, the symbols are transposed. The first symbol should be less than or equal to ≤ and the second should be greater than or equal to ≥.

Figure 14-18 shows the Send Mail Options Screenshot whereas the text relates to the Execute SQL script step.

Note from the Author or Editor:
The figure is wrong. I don't have Geoff's screenshots, but could check them for the right one if given access.