You can change the index or the fields on which your tables are related at any time.
To modify a relationship, follow these steps:
1. | In the Relations dialog, right-click the arrow representing the relationship that you want to modify and select Edit Relation from the pop-up menu. The Edit Relation dialog appears. |
2. | Change the parent key field, child key field or child index as needed and click [OK]. |