VISUAL QUICKPRO GUIDE FileMaker Pro 7 Advanced FOR WINDOWS AND MACINTOSH [Electronic resources] نسخه متنی

Searching for Self- Relationship Data

Instead of using a portal field as a button, you can create a separate button and use it to perform a search in the self-relationship records. In this example, we will create a button that does a Find for all of the people in the company of the current record.

To search for self-relationship data

1 .Go to a layout with the self-relationship portal and switch to Layout mode (Control+L/Command+L).

2 .Click the Button tool, then click and drag on the layout to size and place the button (Figure 6.54). The Specify Button dialog box appears.

3 .

In the list on the left, scroll to the Navigation section and select the Go to Related Record command.

4 .In the Options section on the right click Specify. When the Options dialog box appears, choose the relationship (we use Contacts by Company) in the "Get related record from:" drop-down list.

5 .In the "Show record using layout:" drop-down list, select Current Layout.

6 .Check the "Show only related records" box (Figure 6.55). Click OK twice.

7 .At the flashing cursor, type a title for the button. You can also resize and add color if needed.

When you switch to Browse mode and click the button, the found set of company records will appear.