Errata

FileMaker Pro 8: The Missing Manual

Errata for FileMaker Pro 8: The Missing Manual

Submit your own errata for this product.

The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted By Date submitted Date corrected
Printed
Page xix
3rd paragraph

But now that FileMaker has built-in ways to send data as email or PDFs. designers can spend...

NOW READS:
But now that FileMaker has built-in ways to send data as email or PDFs, designers can spend...

Anonymous    Feb 01, 2006
Printed
Page xxi
5th paragraph

FileMaker Pro comes (with) a printed manual. The word "with" was previously omitted.
This HAS BEEN CORRECTED.

Anonymous    Feb 01, 2006
Printed
Page xxii
4th paragraph

For example there functions for working with text

NOW READS:
For example there are functions for working with text

Anonymous    Feb 01, 2006
Printed
Page xxii
6th paragraph

FileMaker knows your data's important enough to keep safe from prying eyes.

NOW READS:
FileMaker knows your data's important enough to keep it safe from prying eyes.

Anonymous    Feb 01, 2006
Printed
Page xi
1st paragraph

last sentence reads:

... he's always happy to get email from another FileMaker fans

should be:

... he's always happy to get email from other FileMaker fans

Anonymous   
Printed
Page 3
Heading; (The page tabs on for that section are affected to)

An Very Quick Database Tour

NOW READS:
A Very Quick Database Tour

Anonymous    Feb 01, 2006
Printed
Page 10

Figure 1-5 is a screenshot from version 7 templates. Need the one from v8.

Anonymous   
Printed
Page 13
1st paragraph

Last sentence
Says: where it's secure
Should say: where it's more secure

Anonymous   
Printed
Page 38
4th line of text below figure 2-5

....(by putting Smith in the First Name field and California in the state field), ...
Should be:
....(by putting Smith in the Last Name field and California in the state field), ...

Anonymous   
Printed
Page 40
first paragraph

pretty simply rule

NOW READS:
pretty simple rule

Anonymous    Feb 01, 2006
Printed
Page 71
3rd paragraph of Store a Reference box

"This is expecially..." NOW READS "This is especially..."

Anonymous    Feb 01, 2006
Printed
Page 87
Field Naming Conventions

Some database programs aren't so flexible "withnames." A space b
HAS BEEN ADDED between "with" and "names."

Anonymous    Feb 01, 2006
Printed
Page 94
second paragraph, last line

"apply a time format applied to your time fields"

NOW READS:
"apply a time format to your time fields"

Anonymous    Feb 01, 2006
Printed
Page 101
Point #4 under Validation Options

The last sentence NOW READS "The option tells FileMaker to accept no more than five digits..."

Anonymous    Feb 01, 2006
Printed
Page 105
first paragraph, fourth line

...condition.But...

A space HAS BEEN ADDED after period.

Anonymous    Feb 01, 2006
Printed
Page 122
3rd paragraph, last sentence

"You can also seem the same list of layout in the View..."

NOW READS:
"You can also see the same list of layouts in the View..."

Anonymous    Feb 01, 2006
Printed
Page 133
Figure 4-10

The description for Figure 4-10 recommended that you compare this illustration with
Figure 4-9, This reference NOW READS Figure 4-8.

Anonymous    Feb 01, 2006
Printed
Page 134
First paragraph, last sentence

...when your trying to cram...
should be ...when you're trying to cram..

Note from the Author or Editor:
Last sentence first paragraph on the page should read " ... when you're trying to cram a lot of information ..."

Anonymous   
Printed
Page 137
second paragraph, second to last line

"...on your on journey..."

NOW READS:
"...on your own journey..."

Anonymous    Feb 01, 2006
Printed
Page 137
2nd sentence below "Zoom in and out" subheading

NOW READS:
"If the thrill of clicking the zoom
controls in the status area isn't good enough for you, you can alternate
between..."

Anonymous    Feb 01, 2006
Printed
Page 138
Point #3 -- two errors

3. Make sure the "Show in Layout Menu" checkbox is turned on.

NOW READS:
3. Make sure the "Include in layout menus" checkbox is turned on.

ALSO:

In the last paragraph,"Include in layouts menu" NOW READS "Include in layout menus"

Anonymous    Feb 01, 2006
Printed
Page 139
boldface step #5 instruction

Turn off "Show Field Frames when Record is Active."

NOW READS:
Turn off "Show field frames when record is active." Then click OK to close the Layout Setup dialog box.

Anonymous    Feb 01, 2006
Printed
Page 142
top NOTE box

"If you Find FileMaker's..." should be "If you find FileMaker's..." using a lower
case "f" in find.

Anonymous   
Printed
Page 143
2nd paragraph: The line and fill tools, end of last sentence

"use these tools all throughout this chapter"
should read
"use these tools throughout this chapter"

Anonymous   
Printed
Page 150
Note box between points 3 and 4

A space is needed before the last sentence starting with "Now."

Anonymous   
Printed
Page 151
last paragraph in Power Users' Clinic box

Reads: See the box "Locking and Grouping below...
Should read: See the box "Locking and Grouping" on page 154...

Anonymous   
Printed
Page 155
boldface step #1 instruction

Says: choose Edit->Select All
Should say: choose Edit->Select Same

Anonymous   
Printed
Page 155
last paragraph, first sentence

Remove the word "here" as Figure 4-25 is not actually located on this page.

Anonymous   
Printed
Page 155
Field/Control setup paragraph, last sentence

Reads: "But with this dialog box, you're in control..."

It is not very clear which dialog box the author is talking about so
it should read:

"But with Field/Control, you're in charge of how the field accepts
information."

Anonymous   
Printed
Page 157
Point 1

Reads: 1. Choose Format -> Field Borders.
Should read: 1. Choose Format -> Field/Control -> Borders.

Anonymous   
Printed
Page 160
Figure 4-29 graphic

This graphic is missing the Notes field and should be redone in new
editions of this book -- see Figure 4-22 as a comparison. The last
paragraph on this page mentions the Notes field and therefore, it
would be helpful to see what the author is referring to in the
graphic on that page.

Anonymous   
Printed
Page 160
Figure 4-29

The label names do not reflect the changes made to them in previous steps. Phone
instead of Phone Number, Address instead of Street Address ...etc.

Note from the Author or Editor:
Field labels are the original field names and don't show the edits made in previous step-by-step instructions. Don't worry, you can always edit them right on the layout.

Anonymous   
Printed
Page 161
3rd paragraph in Super-Sizing box, 2nd sentence

Previously, the apostrophe found in the word "object's" was in black font rather than white and
thus very hard to read. This HAS BEEN CORRECTED.

Anonymous    Feb 01, 2006
Printed
Page 171
Figure 5-5 box, last sentence

End quotes are missing after the word "Column".

Anonymous   
Printed
Page 177
"Using Symbols..."

"Figure 5-8" NOW READS "Figure 5-7"

Anonymous    Feb 01, 2006
Printed
Page 178
Last sentence in the Tip section

Add a space between FormatDate so it reads "Format Date".

Anonymous   
Printed
Page 183
UP TO SPEED box, first sentence

"...shows you Part Setup Dialog Box."
should be:
"...shows you the Part Setup dialog box."
^^^ ^ ^

Anonymous   
Printed
Page 197
Figure 5-25 Last sentence of the figure caption

text reads
(notice how the second product record starts higher on the page in the left window).
should be
(notice how the second product record starts higher on the page in the right window). ^^^^^

Anonymous   
Printed
Page 223
2nd bullet point at bottom of page

o Another field in the same table.
should be:
o Another field in the same table
(i.e., remove the period at the end of the line)

Anonymous   
Printed
Page 224
2nd paragraph, first sentence

Typo: "press" is misspelled.

Anonymous   
Printed
Page 225
Bold text caption for Figure 6-14, third sentence ( starting with "As you enter ...")

"As you enter data in a repeating field, FileMaker numbers each
repetition in a repeating to let you know which one it is (bottom)",

NOW READS:
"As you enter data in a repeating field, FileMaker numbers each
repetition in a repeating field to let you know which one it is (bottom)",

Anonymous    Feb 01, 2006
Printed
Page 227
1st paragraph in Up to Speed box, 2nd sentence

Put parentheses around "page 157"

Anonymous   
Printed
Page 229
First paragraph below Figure 6-17

Reference to figure 6-18 NOW READS figure 6-17

Anonymous    Feb 01, 2006
Printed
Page 233
4th para, last sentence

In the last sentence, the reference to Figure 6-20 NOW READS Figure 6-18

Anonymous    Feb 01, 2006
Printed
Page 249
Paragraph above the Note

says:
When you're done making choices, click OK. You can now switch to Browse mode and give your button a try.

Should say:
When you're done making choices, click OK. You'll see a cursor blinking on your new button. Type a name
for the button, then hit Enter to confirm the changes. Now you can switch to Browse mode and
give your button a try.

Anonymous   
Printed
Page 251
last line on the page

The reference to Figure 6-35 should be Figure 6-34.

Anonymous   
Printed
Page 252
1st bullet in Power User's Clinic box, 4th sentence

Should read:
"That tells FileMaker to add to the tab order..."

Anonymous   
Printed
Page 259
Point #4

"Then, draw a tab panel like the one in Figure 6-37."
should be
"Figure 6-36."


Anonymous   
Printed
Page 261
in the sidebar - middle of page

The published URL http://www.missingmanual.com/filemaker NOW READS
http://www.missingmanuals.com/cds/9780596005795/

Anonymous    Feb 01, 2006
Printed
Page 262
Reports and Summary Fields, 1st paragraph

"your customer's music tastes"
should be
"your customers' music tastes"

Anonymous   
Printed
Page 267
Point #3

"The field now looks something like those in Figure 6-42"
should be
"Figure 6-41."

Anonymous   
Printed
Page 269
2nd paragraph from the bottom, Tip

(you have to switch to the detail layout first)
should be
(it's helpful to switch to the detail layout first)

Anonymous   
Printed
Page 274
Grey box: Sub-Summary Power, right column, first paragraph, 2nd sentence

"In the right window, though, they're sorted first by state, then by city."
should be
"In the right window, though, they're sorted first by city, then by state."

Anonymous   
Printed
Page 281
Paragraph entitled "Modeling Your Database"

The sentence that reads, "You need to decide what entities you'll be tracking which ones..."

NOW READS:
"You need to decide what entities you'll be tracking, which ones..."

Anonymous    Feb 01, 2006
Printed
Page 289
Last paragraph in the Up To Speed box

Bad breaks: Two of the quotation marks are split from the words they are supposed to be quoting ("lots." and "no more than three.")

Anonymous   
Printed
Page 292
3rd paragraph, 7th sentence

NOW READS:
"In other words, if two entities..."

Anonymous    Feb 01, 2006
Printed
Page 296
Grey box: Going natural, right column, 1st paragraph, 5th line

replace "HR" with "Human Resources"

Anonymous   
Printed
Page 304
Paragraph below figure 7-17

"You can have the database add a person record..."

should read

"add a person's record...."

Anonymous   
Printed
Page 309
Grey box: Lost and found again, left column, 2nd paragraph

"If you still can't fit everything in...you can zoom in on the window"
should read
"If you still can't fit everything in...you can zoom out on the window"

Anonymous   
Printed
Page 317
Payments table fields

"The invoices table..."

NOW READS:
"The payments table is easy too;..."

Anonymous    Feb 01, 2006
Printed
Page 321
center of page: Tip

Remove the word "and" from the first sentence.

In the second sentence,
"...Switch to Layout mode and choose Format -> Field Behavior..."
should be:
"Switch to Layout mode and choose Format -> Field/Control -> Behavior..."

Anonymous   
Printed
Page 324
Figure 7-33 paragraph, 2nd sentence

"but the have" NOW READS "but they have"

Anonymous    Feb 01, 2006
Printed
Page 324
top line after Click OK.

s is missing

"The Add Fields to Portal window take the Portal..."

take should be takes

Anonymous   
Printed
Page 328
1st paragraph, end of 5th line

"the" is missing: should say, " ...make sure that the key field in the table..."

Anonymous   
Printed
Page 336
Item 2 under Go to Related Record

It should read, ...and then change the text color to blue...

Anonymous   
Printed
Page 336
Bottom of page after 1.

Reference should be (page 318) rather than (page 328)

Anonymous   
Printed
Page 339
Point 4, 2nd paragraph

The word "use" is missing in the last sentence. It should read:

(Selecting "Match all records in the current found set" lets you use a new feature...

Anonymous   
Printed
Page 341
GTRR On Steriods box, 3rd paragraph

"current" is missing from the following first sentence. It should read:

Then, in the Options window, select "Show only related records" and "Match all
records in current found set" (the second option is the enhanced part).

also, in the 4th paragraph;
Apply eGTTR liberally ...
should be:
Apply eGTRR liberally ...

Anonymous   
Printed
Page 355
change step one on page 355 to this

1. Add an occurrence of the Invoices table called Expense Assign:
Global Invoice, and occurrence of the Expenses table called Expense
Assign: Expenses, and an occurrence....

Anonymous   
Printed
Page 357
1st paragraph under Using a global pop-up field... section

Delete the extra period at the end of the first sentence. Add a period at the end of
that first paragraph.

Anonymous   
Printed
Page 384
5th bullet item

The sentence NOW READS:
"The result of the first calculation above is the diameter of a circle."

Anonymous    Feb 01, 2006
Printed
Page 426
Tip box

The tip box references how non text fields can have text formatting applied and
suggests that the answer is later in the chapter, but there is no subsequent mention
of how to apply text formatting to date fields.

Author's reply:
The phrase "as you'll see later in this chapter" might imply that
there is a specific instruction set about applying text formatting to
other fields, but it certainly doesn't mention date fields. Maybe it
would be more clear if we just shortened the tip by removing the "as
you'll see later in this chapter" bit.

Anonymous   
Printed
Page 450
First full paragraph.

the calculation given in the book contains two fields not in your database
example for chapter 11: Invoice Amount or Total Paid.

Author's reponse:
She is correct. There is a minor mismatch between the names.
The book calls the field in question "Invoice Amount," but the file
calls it "Total Due." Also, we don't specifically state that people
should create a field called Total Paid, so that will be corrected.

Anonymous   
Printed
Page 488
Figure 13-12

the IF statement needs a "not" operator. ie:
If [Not IsEmpty ( Customers::Email Address )

Anonymous   
Printed
Page 488
figure 13-12

Screen shot is wrong. The second step says "open URL" instead of "send mail".

Also, less importantly, the error message is not the one we were instructed to type
in on page 487, #6.

Thus, the statement on page 487 #8 that "Your script should now look like the one
shown in Figure 13-12." is misleading.

Anonymous   
Printed
Page 518
paragraph under figure 14-10

Add the following xRef:
(also see Figure 13-9, where Resume Script is clearly shown)

Anonymous   
Printed
Page 532
Figure 14-17

The figure shows a cropped version of the send mail window, rather than the full screen shot.

Anonymous   
Printed
Page 566
Step #1

"click the last Set Field step"
should be:
"click the last script step..."

Anonymous   
Printed
Page 567
sidebar, 2nd column, first line

Says: The rational behind
Should say: The rationale behind

Anonymous   
Printed
Page 570
First paragrah under figure 15-25

"The next item left in the TODO list is "Create a line item record."
should be:
"The next item you'll tackle in the TODO list..."

Anonymous   
Printed
Page 570
First paragrah under figure 15-25

It says, "The next item left in the TODO list is "Create a line item record." This
is not true. The next item in the TODO list is "Loop through each record" as shown
in figure 15-25. Looping doesn't appear until p. 577.

Note from the Author or Editor:
First sentence in paragraph just below the figure should read:
"The next item you'll address in the TODO list..."

Anonymous   
Printed
Page 575
Note at the bottom

It says the relationship graph is in fig. 15-28 but it is in 15-27.

Anonymous   
Printed
Page 575
fig. 15-28

Step five in the script says "Set Variable [$$LineItemID; .....

However, step 2 on page 574 said to name it $LineItemID because it can be a local
variable.

Same thing in the two following Set Field steps in fig. 15-28.

Author's response:
This screen shot is wrong. The text is correct.

Anonymous   
Printed
Page 587

Note says: For some reason, you can't duplicate
Should say: You can't duplicate

Anonymous   
Printed
Page 683
caption to Figure 19-9, last sentence

The word "calculation" is misspelled.
Should be: "calculation"

Anonymous   
Printed
Page 686
1st paragraph, last sentence

Says: folks who don't much computer
Should say: folks who don't have much computer

Anonymous   
Printed
Page 694
3rd paragraph

The second sentance reads, "So close the files you want to modify, and then choose
File->Developer Utilities." It should read "Tools->Utilities.

Note from the Author or Editor:
Second to last sentence above the figure on page 694 should read: " ... then choose Tools -> Developer Utilities."

Anonymous