U.M. (Windows)
Table Of Contents
- Preface: Getting help
- Chapter 1: FileMakerPro basics
- Chapter 2: Creating a database file
- Chapter 3: Laying out and arranging information
- Understanding layouts
- Working with predefined layout types
- Arranging records in columns
- Managing layouts
- Working with layout parts
- Changing layout parts
- Working with all object types
- Working with graphic objects
- Working with fields in a layout
- Adding fields to a layout
- Adding merge fields
- Deleting a field from a layout
- Defining display formats for fields
- Determining data entry in fields
- Setting the tab order for data entry
- Adding scroll bars to fields
- Formatting repeating fields
- Adding borders, fill, and baselines to fields
- Defining value lists
- Formatting fields with value lists
- Working with text
- Chapter 4: Working with information in records
- Working in Browse mode
- Adding data to a file
- Selecting a field for data entry
- Adding and duplicating records
- Entering and changing data in fields
- Working with container fields
- Entering data from a value list
- Viewing and inserting data from another source
- Copying and moving values and records
- Using drag and drop to move information
- Replacing field values
- Working with records
- Finding information
- Deleting records
- Sorting records
- Chapter 5: Using ScriptMaker and buttons
- Chapter 6: Previewing and printing information
- Chapter 7: Networking and access privileges
- Chapter 8: Importing and exporting data
- Chapter 9: Customizing FileMakerPro
- Chapter 10: Using data from related files
- Chapter 11: Publishing files on the Web
- About the World Wide Web
- About FileMaker Pro Web Companion
- Publishing your database on the Web—an overview
- Getting ready to publish your files on the Web
- Setting up FileMaker Pro Web Companion
- Configuring FileMaker Pro Web Companion
- Setting up Instant Web Publishing
- Database security
- Helping Web users find your database
- Custom Web Publishing
- Appendix A: Recovering damaged files
- Appendix B: Working with international files
- Appendix C: Summary of functions
- Appendix D: Linking and embedding objects
- Index
Creating a database file 2-19
Stored and unstored calculation results
You can have FileMaker Pro:
1 perform a calculation whenever the data that the calculation is based
on changes, and store the result in the calculated field (a stored result)
1 perform a calculation and display the result only when you need to
use the data—for example, to browse or print records—(an unstored,
or virtual, result)
In most cases, FileMaker Pro makes a field stored when you define the
field. You can change the storage type to unstored.
Keep these points in mind:
1 FileMaker Pro makes a calculated field unstored when its formula
refers to a global field, an unstored calculated field, a related field, or
a calculation that includes a summary field.
1 Stored results use more disk space. Unstored results take more time
to calculate.
¶ Return marker Inserts a paragraph return in a
text constant
"M.T.N.Trek¶Sporting¶
Equipment" returns
M.T.N. Trek
Sporting
Equipment
(The ¶ symbol must be
enclosed within the quotation
marks of the text constant).
Choose FileMaker Help Index from the Help menu, and then type:
E text operators
Choose FileMaker Help Index from the Help menu, and then type:
E calculation fields
Symbol Name Definition Examples
?
?