User manual
Table Of Contents
- Preface Learning how to use FileMakerPro
- Chapter 1 FileMaker Pro basics
- Chapter 2 Adding and viewing data
- Chapter 3 Finding and sorting information
- Finding records
- Finding text and characters
- Finding exact matches in text fields
- Finding numbers, dates, and times
- Finding ranges of information
- Finding data in related fields
- Finding records that match multiple criteria
- Finding empty or non-empty fields
- Finding duplicates
- Finding all records except those matching criteria
- Hiding records from a found set and viewing hidden records
- Viewing, repeating, or changing the last find
- Sorting records
- Finding records
- Chapter 4 Previewing and printing information
- Chapter 5 Creating a database
- Chapter 6 Creating and managing layouts and reports
- Chapter 7 Customizing layouts
- Chapter 8 Working with related files
- Chapter 9 Protecting databases with passwords and groups
- Chapter 10 Creating scripts to automate tasks
- About scripts
- Creating scripts: an overview
- About ScriptMaker steps
- Control script steps
- Navigation script steps
- Sort, find, and print script steps
- Editing script steps
- Fields script steps
- Records script steps
- Windows script steps
- Files script steps
- Spelling script steps
- Open Menu Item script steps
- Miscellaneous script steps
- Changing scripts
- Duplicating, renaming, or deleting scripts
- Importing scripts
- Listing scripts in the Scripts menu
- Using buttons with scripts
- Example of a ScriptMaker script
- Chapter 11 Using formulas and functions
- Chapter 12 Importing and exporting data
- Chapter 13 Sharing databases on a network
- Chapter 14 Publishing databases on the Web
- About publishing databases on the Web
- How users work with databases on the Web
- What you need to publish databasesontheWeb
- Publishing databases on the Web: an overview
- Enabling FileMaker Pro Web Companion
- Configuring FileMaker Pro WebCompanion
- Enabling Web Companion sharing
- Setting up browser views
- Testing your published database
- About browser views for web publishing
- Chapter 15 Using ODBC with FileMakerPro
- Appendix A Customizing FileMaker Pro
- Appendix B Backing up and recovering files
- Appendix C FileMaker Pro Quick Reference (Windows)
- Appendix D FileMaker Pro Quick Reference (Mac OS)
- Index
5-12
FileMaker Pro User’s Guide
3. Click Done.
Keep these points in mind:
1 If you change a calculation formula or summary type,
FileMaker Pro recalculates the value for every record in the database
when you exit the Define Fields dialog box.
1 To change the definitions of related fields, make the changes in the
related file.
Deleting field definitions and data
Important Deleting a field in the Define Fields dialog box
permanently and irretrievably deletes the field definition and all the
data in that field in all your records. Before you delete a field from a
file, be sure you don’t need any data the field contains.
1. Choose File menu > Define Fields.
2. In the Define Fields dialog box, select one or more fields, then
click Delete.
3. Click Delete again, or click Cancel to leave the fields unchanged.
4. Click Done.
Keep these points in mind:
1 To remove fields from a layout, but leave them available in the
database, see “Placing and removing fields on a layout” on
page 6-15.
1 For more information about deleting field definitions, choose Help
menu > Contents and Index, click the Index tab, and type field
definitions.
Change a summary
field
In the field list, double-click the summary field, then
make your changes in the Options for Summary Field
dialog box. Click OK. See “Defining summary fields” on
page 5-6.
Reorder field
names in dialog
boxes that list
fields
See FileMaker Pro Help. Choose Help menu > Contents
and Index, click the Index tab, and type reordering.
To Do this