Quick Start
Table Of Contents
- Chapter 1 Welcome to FileMaker Pro
- Chapter 2 Installing FileMaker Pro in Windows
- Chapter 3 Installing FileMaker Pro in the Mac OS
- Chapter 4 New features in FileMaker Pro
- The user interface’s new look
- New Layout/Report assistant
- Other layout improvements
- ODBC support in FileMakerPro
- Microsoft Excel import and file conversion
- ActiveX Automation support (Windows)
- QuickTime
- Web publishing
- View as Table
- Improvements to value lists
- Import script
- Import Update
- Multi-User (Hidden)
- Hands-on, task-oriented tutorial
- Lesson 1 FileMaker Pro basics
- Lesson 2 Browsing information
- Lesson 3 Finding and sorting records
- Lesson 4 Creating a database and entering records
- Lesson 5 Customizing what you see
- Lesson 6 Creating lists, mailing labels, and form letters
- Lesson 7 Simplifying data entry
- Lesson 8 Automating tasks with buttons and scripts
- Lesson 9 Creating and running reports
- Lesson 10 Making databases relational
- Lesson 11 Keeping your data safe
Making databases relational
79
Arrange the fields in the portal
1. Make the first portal row (the white part at the top of the portal)
tall enough to hold a field.
2. Using the Field tool , drag a field into the first portal
row.
3. Select the ::First Name field and click OK.
4. Drag another field beside ::First Name and specify ::Last Name.
5. Move the First Name and Last Name field labels above the portal,
above their respective fields.
The portal should look like this when you are done.
6. Choose View menu > Browse Mode to view your list of members.
7. Test your new structure: type the name of a new member at ABC
Company, then look to see if it appears in MyMembers10.fp5 (it will
be the last record).
8. When you are finished with this lesson, Exit or Quit
FileMaker Pro to close all open files.
For more information
You have seen how to use and create simple one-to-one and one-to-
many relationships. This tutorial covers just the basics; there are
many important points to consider when building a relational
database system. Be sure you read chapter 8 in the FileMaker Pro
User’s Guide before using relational structures in your own files.