User manual
Table Of Contents
- Contents
- Chapter 1 Introducing FileMaker Pro
- Chapter 2 Using FileMaker Pro
- About fields and records
- Opening and closing files
- Opening multiple windows per file
- Saving files
- About modes
- Viewing records
- Adding and duplicating records
- Deleting records
- Entering data
- Working with data in Table View
- Finding records
- Sorting records
- Previewing and printing files
- Backing up files
- Setting preferences
- Chapter 3 Designing and creating solutions
- Planning a solution
- Creating a FileMaker Pro file
- Creating and changing fields
- Setting options for fields
- Creating database tables
- Creating layouts and reports
- Working with layout themes
- Working with layout object, part, and background styles
- Setting up a layout to print records in columns
- Working with objects on a layout
- Working with fields on a layout
- Working with layout parts
- Creating and editing charts
- Chapter 4 Working with related tables and files
- Chapter 5 Sharing data
- Sharing databases on a network
- Importing and exporting data
- Supported import/export file formats
- Setting up recurring imports
- ODBC and JDBC
- Methods of importing data into an existing file
- About adding records
- About updating existing records
- About updating matching records
- About the importing process
- Converting a data file to a new FileMaker Pro file
- About the exporting process
- Working with external data sources
- Publishing solutions on the web
- Chapter 6 Protecting files
- Protecting databases with accounts and privilege sets
- Creating accounts and privilege sets
- Viewing extended privileges
- Authorizing access to files
- Security measures
- Enhancing physical security
- Enhancing operating system security
- Establishing network security
- Backing up databases and other important files
- Installing, running, and upgrading antivirus software
- Chapter 7 Using FileMaker Pro Advanced
- Index
Chapter 3 | Designing and creating solutions 46
Creating and changing fields in the Field Picker dialog box
When you create a new file, FileMaker Pro opens the file in Layout mode, and displays a blank
layout and the Field Picker dialog box. Use the Field Picker dialog box to define fields for the file,
and to add or change fields for an existing layout.
Note Fields are not automatically added to the layout when you define them in the Field Picker
dialog box. To have fields placed on a layout when you define them, select Add newly defined
fields to current layout in the Layout tab of the Preferences dialog box before you define the
fields.
1. If the Field Picker dialog box is not open, in Layout mode, click in the layout bar.
2. In the Field Picker dialog box, add, delete, or change fields.
To Do this
Add a field Click New Field. A placeholder Field is created in the fields list, with a field
type assigned. With the field selected, type a new name for the field. See
“About naming fields” on page 43.
Change the field type Click the field type and choose a new field type from the list. See “About
choosing a field type” on page 44.
Important Changing the field type can permanently and irretrievably
erase data.
Set options for the field Right-click the field and choose Field Options. See “Setting options for
fields” on page 50.
Delete a field Right-click the field and choose Delete Field.
To delete multiple fields at a time, select the fields, then right-click and
choose Delete Field.
Important Before you delete a field, confirm that you don’t need any of
the data it contains.
Change a field’s name Windows: Double-click the field, then type a new field name.
OS X: Select the field, then click the field name and type a new field name.
Display the Manage
Database dialog box
Click to add a field to
the database
Fields appear here
as you add them
Specify settings for position
and labels of fields dragged
to the layout
Search for fields
Sort fields