VISUAL QUICKPRO GUIDE FileMaker Pro 7 Advanced FOR WINDOWS AND MACINTOSH [Electronic resources]

Creating a Match Field in the Current Table

To use data from the source table you've created a match field in, you also need a match field in the current (destination) table. Once you have both match fields, you define a relationship that links the receiver to the source.

To create a match field in a current table

1 .In the destination file, go to File > Define > Database (Control+Shift+D/Command+Shift+D). Click the Fields tab.

2 .Define a new number field and name it. This example is named Key Serial to match the source field of the same name. Click Create, then OK.

3 .If the table you are creating the relationship to is not contained in the same database, follow the steps in "To create a file reference" in the preceding section.

4 .

Choose File > Define > Database (Control+Shift+D/Command+Shift+D). When the Define Database dialog box appears, click the Relationships tab. In the Tables/Relationships section, click the Add Table button (Figure 6.11).

5 .When the Specify Table dialog box appears, select a file reference from the File drop-down menu (Figure 6.12), then choose the table to be related. Click OK.

6 .In the Tables/Relationships section of the Relationships tab, click the Create Relationship button (Figure 6.13).

7 .

When the Edit Relationship dialog box appears, choose the current table occurrence in the left table drop-down list. Choose the related table occurrence in the right drop-down list (Figure 6.14).

8 .Click the Key Serial field in the field lists under both tables, then click the Add button (Figure 6.15). Click OK.

The new relationship will be shown as a connecting arrow in the Relationships graph (Figure 6.16).