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).
Figure 6.11. To define a new relationship, begin by adding the source table.
[View full size image]

Figure 6.12. To relate a table to the current one, choose the source table from the drop-down list.

Figure 6.13. Manage relationships through the Tables/Relationships buttons.

Figure 6.14. Choose the related table from the drop-down list on the right.
[View full size image]

Figure 6.15. Choose the key fields in both tables from each field list.
[View full size image]

Figure 6.16. The new relationship appears in the Relationships graph as a line connecting the key fields.
[View full size image]

