User manual

Chapter 7 | Using FileMaker Pro Advanced 134
2. Perform the following tasks:
1 To add an expression, click . In the Edit Expression dialog box, build an expression, then
click Monitor to add the expression to the Data Viewer.
1 To edit an expression, double-click the expression in the Watch tab or select an expression
and click
. Define or edit the expression. Then, click Evaluate Now to display the result
of the expression or click Monitor to add the expression to the Watch list.
Documenting database schemas
With the Database Design Report (DDR) feature you can:
1 examine a textual representation of your database schema
1 gather statistics on the structure of your database
1 produce reports in HTML or XML for any databases that are currently open, either locally or on
a network
1 use the information in the report to re-create the structure of your database if you lose the
original database files
1 troubleshoot missing references, broken relationships, calculations, and more
Select mathematical and
text operators
Choose field
references
Formula
Select comparison and
logical operators
Choose the way
functions are listed in
this dialog box
Click to evaluate the
expression
Click to add the
expression to the
Data Viewer
Result of the
expression
Table name
Select
functions to
use in the
expression