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
2-4 FileMaker Pro User’s Guide
5. Define the fields you want for the file, and then click Done.
When the file is new, you see the fields in Browse mode. Otherwise, you
return to where you were before you defined fields.
Assigning a field type
When you define a field, you must decide the kind of data it will contain
and then select the appropriate field type. FileMaker Pro uses the field
type to interpret the data when sorting and performing calculations. The
following table explains each field type.
Choose FileMaker Help Index from the Help menu, and then type:
E adding new fields
Select this
field type If the field’s data will be
Text Up to 64,000 characters of letters, symbols, and numbers used as text.
You can sort records based on a text field and use a text field in formulas
for calculations and summary fields. Text fields are usually sorted
alphabetically (from first character to last character in the alphabet, or last
to first), starting with the first character in the field. For more
information, see “Sorting records” on page 4-29.
Number Up to 255 characters of numbers or other characters, of which only the
numbers are treated as numeric. You can sort records based on a number
field and use number fields in formulas for calculations and summary
fields. Number fields are sorted numerically (lowest to highest or highest
to lowest), based on the numeric part of the data.
Field names and definitions
Type a name for a new field
Select a field type
After you type a field
name and select a field
type, click Create
Choose the way fields are
listed in the dialog box
?