CorelTUTOR Home Tile Help
Restart Back Forward

Linking tables in the Data Model Designer

In Lesson 1 you created a referential integrity relationship, also referred to as a link, between the Account and the Stock Orders tables. If you are using the sample files, a link already exists between the Account and the Stock Orders tables. However, even though the link exists in the tables, you must re-create it in the Data Model Designer for it to appear in the data model. Click here to view the finished data model.

To create a link in the Data Model Designer

  1. Click Edit menu Links.
  2. Click New.
  3. Choose Account.db from the Parent table list box.
  4. Choose Stock orders.db from the Child tables list box.
  5. Choose AccountNumber from the Parent fields list.
  6. Click the Right arrow button.
  7. Choose AccountNumber from the Child fields list.
  8. Click the Left arrow button.
  9. Click OK.

To close the Links dialog box

Continue