I think he was asking how to make a relationship in the first place.
On the main database window (make sure its highlighted and no forms, tables, queries, reports, etc are open), go to tools and click on relationships.
There is also a tool bar icon, but sometimes hard to find.
In the window that opens, right click on it and choose add table.
click on the tables you want to make relationships with. Show what you want by clicking add, then hit close.
after that, simply drag from one table to the other table by clicking on the name of the field you want to link and dragging it to another table and dropping it ON THE FIELD you want to link to.
When you do that, a window will open, you will see 3 boxes at the bottom of this window. One can be clicked on (Enforce Referential Integerity) and the other two are greyed out, unusuable.
When you click on the one available, (Enforce Referential Integerity) the other two will light up.
This checkbox will create a link between the tables and make sure that the data between the two tables are always linked.
The other two options do this.
Cascade Update: This will change all records in the "subtable" when changes are made to the "master table."
Cascade Delete: This will delete ALL records in subtables related / linked to the record in the master table if you delete the record in the MASTER TABLE.
