How to edit a join

A database join can be modified (for example, if the fields involved in the join change).

To edit a join

1. On the SQL tab, expand Tables, and expand the table containing the join to be edited.
   
   
2. Expand Joins, and then double-click the join to edit.
   
   
3. In the Join/New Join dialog, select the join to edit.
   
   
4. Click Edit.
   
   
5. In the Join Condition box, edit the source table and/or destination table fields, and click OK.

See Also

Join/New Join Dialog Box

Model Editor

SQL Tab (Model Editor)