U.M. (Mac OS)
Table Of Contents
- Preface: Getting help
- Chapter 1: FileMakerPro basics
- Chapter 2: Creating a database file
- Chapter 3: Laying out and arranging information
- Understanding layouts
- _
- Working with predefined layout types
- Arranging records in columns
- Managing layouts
- Working with layout parts
- Changing layout parts
- Working with all object types
- Working with graphic objects
- Working with fields in a layout
- Adding fields to a layout
- Adding merge fields
- Deleting a field from a layout
- Defining display formats for fields
- Determining data entry in fields
- Setting the tab order for data entry
- Adding scroll bars to fields
- Formatting repeating fields
- Adding borders, fill, and baselines to fields
- Defining value lists
- Formatting fields with value lists
- Working with text
- Chapter 4: Working with information in records
- Working in Browse mode
- Adding data to a file
- Selecting a field for data entry
- Adding and duplicating records
- Entering and changing data in fields
- Working with container fields
- Entering data from a value list
- Viewing and inserting data from another source
- Copying and moving values and records
- Using drag and drop to move information
- Replacing field values
- Working with records
- _
- Finding information
- Deleting records
- Sorting records
- Chapter 5: Using ScriptMaker and buttons
- Chapter 6: Previewing and printing information
- Chapter 7: Networking and access privileges
- Chapter 8: Importing and exporting data
- Chapter 9: Customizing FileMakerPro
- Chapter 10: Using data from related files
- Chapter 11: Publishing files on the Web
- About the World Wide Web
- About FileMaker Pro Web Companion
- Publishing your database on the Web—an overview
- Getting ready to publish your files on the Web
- Setting up FileMaker Pro Web Companion
- Configuring FileMaker Pro Web Companion
- Setting up Instant Web Publishing
- Database security
- Helping Web users find your database
- Custom Web Publishing
- Appendix A: Recovering damaged files
- Appendix B: Working with international files
- Appendix C: Summary of functions
- Index
Importing and exporting data 8-7
7. Select an option to add or replace records, and then click Import.
8. If you see the Import Options dialog box, select options, and then
click OK.
FileMaker Pro displays this dialog box if your file has lookups or
fields that automatically enter data, or if you’re importing data from
a FileMaker Pro file with repeating fields and select the Add new
records option.
To Do this
Add new records to the end of the
file you’re importing into
Select Add new records.
Replace existing data in the file
you’re importing into
Select Replace data in current found set. FileMaker Pro
replaces field values in the found set of the file you’re
importing into.
To Do this
Enter default data into
fields that are defined with
Auto Enter options or as
lookups
Select Perform auto-enter options while importing.
After importing data, FileMaker Pro enters default data
into fields with Auto Enter options. Some Auto Enter
options (like modification date, time, and name, and
lookups) overwrite the imported data. (See “Choosing data
entry options” on page 2-6 and “Defining a lookup” on
page 10-11.)
Fields in the
destination file
Fields in the source file
Arrows show how
FileMaker Pro imports data
from one file into the other
Dotted lines
show data that
won’t be
imported