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
- Quick Reference
10-20 FileMaker Pro User’s Guide
Creating a relational database
After you’ve planned your relational database, follow these general
steps to create it (detailed instructions follow):
1. Define the relationships to use.
2. Depending on whether you want to work with data from one related
record or more than one in each record in the master file, add related
fields directly in the layout or in a portal in the layout.
1 For a related field by itself, add the related field directly in
the layout.
1 For related fields in a portal, create the portal in the layout, and
then add the related fields in the portal.
You add related fields and portals in Layout mode and then work with
data from the related records in all modes.
Deciding where to place related fields
You can display related fields directly in a layout or inside a portal.
1 Place related fields directly in the layout to display data from the first
related record in the related file, even when the match field in the related
file contains more than one occurrence of the same value. (A related
field directly in a layout establishes a one-to-one correspondence
between data in the master file and data in the related file.)
1 Place related fields in a portal in the layout to display data from all
found related records in the related file. (A portal establishes a one-
to-many correspondence between data in the master file and data in
the related file.)