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.
| Version |
Location |
Description |
Submitted By |
Date Submitted |
Date Corrected |
| 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 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 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
top line after Click OK. |
s is missing
"The Add Fields to Portal window take the Portal..."
take should be takes
|
Anonymous |
|
|
| Printed |
Page 324
Figure 7-33 paragraph, 2nd sentence |
"but the have" NOW READS "but they have"
|
Anonymous |
|
Feb 01, 2006 |
| 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 |
|
|