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-5
If the field is defined to enter field values automatically, you see
those values entered in the new record. See “Defining automatic data
entry” on page 5-8.
To enter or change values in the new record, see “About entering
data in records” on page 2-6.
Adding and duplicating related records
If you’re working with related files, you can add records to the
related file as you enter data in a record in the master file.
Note You can only add related records from the master file if the
relationship is defined to allow the creation of related records. (See
“Defining relationships for relational databases and lookups” on
page 8-10.)
For more information about related files, see “Displaying data from
related files” on page 8-1.
Deleting records
When you delete a record, you permanently discard the data in all the
fields in that record.
Important You can’t retrieve deleted data, and you can’t undo the
action of deleting records. Before you delete records, consider
making a backup copy of your file.
To Do this in Browse mode
Create a record in the
master file
Choose Records menu > New Record.
Add a record to a
related file
1 If the related field is in a portal, type data into the field
in the last (empty) row of the portal, then press Tab.
1 If the related field isn’t in a portal, type data into the
field, then press Tab.
Duplicate a master
record (and display
related data)
Be sure no records in a portal are selected, then choose
Records menu > Duplicate Record.
Duplicate a related
record in a portal
Select the record in the portal, then choose Records menu
> Duplicate Record.
Portal displaying
related records from
the Line Items file
Master file
Type in the last row of the
portal to add a related
record to the Line Items file