Tutorial
Table Of Contents
- Contents
- Lesson 1 FileMaker Pro basics
- Lesson 2 Browsing information
- Lesson 3 Finding and sorting records
- Find records based on criteria in a single field
- Find records based on criteria in separate fields
- Find records that match multiple criteria in the same field
- Find records that match a range of criteria in the same field
- Narrow your search
- Save a find request for later use
- Find records using a Saved Find
- Sort your found set
- Add a new record in List View
- For more information
- 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 Sharing and exchanging data
- Lesson 12 Protecting data in FileMaker Pro
- Lesson 13 Keeping your data safe
70 FileMaker Pro Tutorial
Add the fields in the portal
1. In the Add Fields to Portal dialog box, select the ::First Name field and move it to the Included fields list.
2. Select and move the ::Last Name field.
3. Click OK.
4. Use the Text tool in the status toolbar and create field labels for the First Name and Last Name field
labels above their respective fields in the portal.
The portal should look like this when you are done.
5. Click Save Layout, then click Exit Layout to view the list of members in each company.
6. Test your new structure: type the name of a new member at ABC Company, then switch to the Data Entry
layout and look to see if it appears as last record.
When you added the new member, the relationship automatically created a record for him or her in the
Members table. ABC Company is automatically entered into the match field because the name was added
to the portal of the ABC Company record.
7. When you are finished with this lesson, close the file by choosing File menu > Close.
For more information
You have seen how to use and create simple relationships. This tutorial covers just the basics; there are many
important points to consider when building a relational database system. Be sure to read chapter 4 in the
FileMaker
Pro User’s Guide and the relational information in FileMaker Pro Help before using
relationships in your own files.
Displays a list of
members from the
related table
Click here to enter a
new member for
this company