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
Contents
v
About working with objects on a layout
6-11
Working with the layout tools
6-11
Selecting objects
6-12
Copying, duplicating, and deleting objects
6-13
Moving objects on a layout
6-14
Changing an object’s shape and size
6-14
Protecting objects from change
6-15
About working with fields on a layout
6-15
Placing and removing fields on a layout
6-15
Deciding where to place related fields
6-18
Formatting field data on a layout
6-21
About layout parts
6-25
About layout part types
6-25
Adding or changing layout parts
6-26
Defining page breaks and numbering
6-29
Reordering layout parts
6-29
Resizing layout parts
6-30
Deleting layout parts
6-30
Chapter 7
Customizing layouts
Customizing fields on a layout
7-1
Adding borders, fill, and baselines to fields
7-1
Adding scroll bars to fields
7-2
Defining a list of values for data entry
7-3
Formatting repeating fields
7-7
Allowing or preventing entry into fields
7-8
Setting the tab order for data entry
7-8
Customizing the appearance of a layout
7-10
Adding text to a layout
7-10
Formatting text 7-12
Drawing lines and shapes 7-14
Setting color, pattern, line width, and object effects 7-14
Inserting graphics onto a layout 7-16
Formatting graphics on a layout 7-17
Showing text, field, or button boundaries 7-17
Arranging objects 7-17
Grouping and ungrouping objects 7-17
Moving objects forward or backward on a layout 7-18
Rotating objects 7-18
Aligning objects to each other 7-18
Using tools to precisely position objects 7-19
Using the Size palette with objects 7-19
Using graphic rulers and ruler gridlines 7-20
Aligning objects with the T-squares 7-20
Using the object grids 7-21
Controlling how things print 7-21
Specifying page margins 7-21
Showing page margins 7-22
About removing blank space from printed data 7-22
Keeping objects from printing 7-25
Chapter 8
Working with related files
Displaying data from related files 8-1
Relational database terminology 8-2
About relational databases 8-2
When to create relationships between files 8-4
About match fields for relationships 8-5
About lookups 8-6
Relational databases and lookups: a comparison 8-7
Working with relational databases 8-7
Planning a relational database 8-7
Creating relational databases: an overview 8-9
Defining relationships for relational databases
and lookups
8-10
Changing relationships 8-12
Choosing a different relationship for a portal 8-12