U.M. (Windows)
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
- Appendix D: Linking and embedding objects
- Index
1-4 FileMaker Pro User’s Guide
What’s a FileMaker Pro database file?
Each FileMaker Pro database file contains information about the file’s
structure, like fields and their definitions, access privileges and
passwords, calculations, layouts, and scripts. A FileMaker Pro database
file also contains the data you enter and work with.
Fields and field definitions
Fields are the basis of a database file. Fields store, calculate, and display
the data you have entered or calculated. For example, you might create
a field named Tour Name to hold a descriptive name for each tour you
add to a Tours database file.
The information you put into a field—by typing, copying, looking up, or
importing—is its value. Field values in a FileMaker Pro file can be:
1 text
1 a number
1 a date
1 a time
1 a graphic, sound, movie, or OLE object
1 the result of a formula that calculates the field’s value
1 a summary of the values in the field for a group of records
Each field has a set of characteristics that defines how it will store,
display, and interpret data, and whether the value is typed or entered into
the field or is the result of a calculation. These characteristics are the
field definition. You create a field in a file and define it to suit your
needs. For example, the type of data in the field and whether to calculate
the field’s value are both part of the field definition.