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
4-10 FileMaker Pro User’s Guide
Viewing and inserting data from another source
To maintain consistency across records, you can do the following:
1 View values in the index (when a field is indexed), which contains all
the values in the currently selected field and insert them into the
current field.
1 Insert the current date, time, or user name.
Working with the index
When you have field values indexed (by selecting storage options in the
Entry Options dialog box), FileMaker Pro indexes the values in each
text, number, date, time, and calculation field. You can view the values
in a field’s index, and insert them into the field to prevent typing
duplicate values incorrectly. (To index fields, see “Indexing fields” on
page 2-12.)
Note Inserting values from the index is useful in Find mode. In Browse
mode, prevent errors by creating a value list and inserting values from
the list into the currently selected field instead of pasting values from the
index. (See “Defining value lists” on page 3-75.)
1. Select the field to hold a value from the index.
To replace the current field value, select the data to replace. To select
the entire contents of the field, choose Select All from the Edit menu.
Choose FileMaker Help Index from the or Help menu, and then type:
E entering data
Type a value to
enter in the field
?