Database Reference
In-Depth Information
"You should see my " Car
FileMaker shows you a warning message that says, “An operator (e.g. +, -, *, …) is expected
here” when you try to click OK to close the Specify Calculation dialog box (
Figure 9-4
)
. The
characters “Car” are highlighted in your calculation so you can tell exactly which part of the
calculation confuses FileMaker. Add an ampersand to the end of the text constant, and
FileMaker will stop complaining. Here's the correct formula that combines the text constant
with the value that appears in the field named Car:
"You should see my " & Car
Figure 9-4. When you click OK, FileMaker tries to evaluate your calculation. If it finds any part of
the formula that seems like it should be a field name, but there's no field with that name, then you
see this error message. Notice that in the window behind the warning, FileMaker highlights the
part of your calculation it doesn't understand. Sometimes you've made a typing error, but some-
times the field you want is in another table.
