Editing relationships

Previous page
Table of content
Next page

Suppose in the previous steps, you accidentally connected the wrong fields. Editing the relationship is easy, so you can change the relationship any time.

To change or edit relationships

1.

If necessary, reopen the Define Database dialog box by choosing File > Define > Database ( in Windows, on the Mac).

2.

When the Define Relationships dialog box appears, the Relationships tab is selected automatically (assuming you used the same tab when you last opened the dialog box). Click the Edit table button () or double-click the box astride the line connecting the two fields (Figure 10.13).

Figure 10.13. To change or edit a relationship, doubleclick the mathematical operator astride the line connecting the files.


3.

When the Edit Relationship dialog box appears, you can select a new field on the left or right, as well as the = drop-down menu between the lists to change the mathematical operator (Figure 10.14). When you're done, click OK to close the dialog box and apply the change.

Figure 10.14. Use the Edit Relationship dialog box to select a new field on the left or right, or click the = drop-down menu to change the mathematical operator. (See Table 10.2 for details about the bottom options.)


Tips