Tutorial
Table Of Contents
- Contents
- Lesson 1 FileMaker Pro basics
- Lesson 2 Browsing information
- Lesson 3 Finding and sorting records
- Use quick find to search a database
- Find records based on criteria in a single field
- Find records based on criteria in specific 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 to use later
- 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 Charting data
- Lesson 11 Making databases relational
- Lesson 12 Sharing and exchanging data
- Lesson 13 Protecting data in FileMaker Pro
- Lesson 14 Backing up your databases
Lesson 11
|
Making databases relational 81
Display a list of related records
Relationships are bidirectional. The relationship you made between the Members and Companies tables
displays data (company addresses) from the Companies table. Next, you will use the same relationship to
display data (member names) from the Members table.
Create a portal to display matching records
You can add a portal on a layout to display data from related fields.
1. Choose the Companies layout from the Layout pop-up menu.
A relationship must always be defined before you can display data from related records. Now you will
use the relationship to the Members table you defined earlier in this lesson, but first the relationship must
be changed to allow the creation of related records.
2. Choose File menu > Manage > Database, and click the Relationships tab, if it isn’t already selected.
3.
In the relationships graph, double-click the relational operator to display the Edit Relationship dialog box.
4. At the bottom of the dialog box under Members, select Allow creation of records in this table via this
relationship. This lets you add a name to the Members list.
5. Click OK, then click OK again to close the Manage Database dialog box.
6. Use the book or slider in the status toolbar to move to the first company record (ABC Company).
7. Click Edit Layout.
8. Select the Portal tool in the status toolbar and draw a box on the layout to hold the list of names.
9. In the Portal Setup dialog box, for Show related records from choose the Members table.
10. Select Show vertical scroll bar.
11. Leave the Initial row value at 1. Change the Number of rows value to 7.
12. Click OK.
Select this
checkbox