Database Reference
In-Depth Information
•
Filters
:
This is where you record the criteria that the view will use to filter the re-
cords it displays. You'll record both the field being tested and the expression used
to test it.
Note
When you fill out the Calculated Field Expressions and Filters sections of a View
Specifications sheet, use the expressions with which you are most familiar. You'll
modify them as necessary when you implement the database in an RDBMS.
Fill out a View Specifications sheet for each view that you create, and attach the sheet to
the proper view diagram. Both of these items will serve to document the view fully.
Fig-
ure 12.16
shows a completed View Specifications sheet for the CUSTOMER CALL LIST
view. (Keep in mind that the view has been updated to include the C
UST
S
TATE
field.)
