Datasheet

14. At this point, all of your tables have been created and their primary keys have been set. You need
to add the foreign key relationships between your tables. Double-click the GroupProjects table.
When the Table Designer is displayed, click the Table Designer menu and choose Relationships
or click the Relationships icon on the toolbar. The Foreign Key Relationships dialog box is
displayed and this is where you define the primary and foreign relationships between your
tables.
15. Click the Add button in the Foreign Key Relationships dialog box. In the Properties window,
click the Tables and Columns Specification property as shown in Figure 1-10. Then click the
elipse button for this property to display the Tables and Columns dialog box.
Figure 1-10
16. In the Tables and Columns dialog box, select the Groups table in the Primary key table combo
box and then click in the empty row under this combo box and select GroupID in the combo box
that is displayed. In the first row under the Foreign key table column, select GroupID in the
combo box that is displayed there as shown in Figure 1-11. When you are done, click OK to
return to the Foreign Key Relationships dialog box.
Figure 1-11
23
Databases
04_58894x ch01.qxd 10/13/05 5:54 PM Page 23