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
 
Adding and viewing data 
2-9
Note  If you have layout design privileges, you can set field format 
options to determine how fields appear on a layout. For example, the 
format determines whether the Other or Edit items appear in radio 
buttons, checkboxes, and pop-up lists or menus. See “Formatting 
fields to use a pop-up list, pop-up menu, checkboxes, or radio 
buttons to display a value list” on page 7-6.
Moving data with drag and drop
You can use drag and drop to transfer information within a 
FileMaker Pro file, or between FileMaker Pro and other applications 
that support drag and drop.
For example, you can drag a number from one field and drop it in 
another field in the same database. Or, you can drag an object from 
a FileMaker Pro layout and drop it into a Microsoft Word document.
In FileMaker Pro, you can use drag and drop in Browse mode, Find 
mode, or Layout mode. To enable or disable the drag and drop 
feature for text in Browse mode or Find mode, select or clear Enable 
drag and drop text selection in the General area of the Application 
Preferences dialog box. See “Setting general application 
preferences” on page A-1.
For more information about drag and drop, choose Help menu > 
Contents and Index, click the Index tab, and type 
drag and drop. 
To  Do this in Browse mode
Choose preset value from 
a pop-up (drop-down) list 
or menu
Click the field, then choose the value from the pop-
up list or menu.
Deselect a list Press Esc, or click the field again.
Type a value that isn’t 
included in a pop-up list
Click the field again, then type the value. 
Note  You must type a value that’s in the list if the 
Member of value list validation option is selected for 
the field. See “Defining field validation” on 
page 5-9.
Select or clear a radio 
(option) button
Click the button to select a value. 
To clear a button, Shift+click it.
Select or clear a checkbox Click a checkbox to select or clear a value.
Enter a value that isn’t 
included in a value list
Choose or click Other. Type a value in the dialog 
box, then click OK.
Clear an Other item Choose or click Other, then delete the associated 
value (and its carriage returns) in the dialog box. 
Click OK. (This action clears the field.)
Edit a value list Choose Edit, then change the values in the dialog 
box. Click OK.
Checkboxes
Radio buttons
Pop-up list 
Pop-up menu
Click to enter a value that 
isn’t included in the list 
Choose to edit
values in the list










