Adding the Suppliers Table Step 4. Close the Show Table dialog box by pressing the Close button. If all goes well, you will see both the Products table and the Suppliers table in the design view window. The Products and the Suppliers tables both displayed The line running from Products to Suppliers denotes a many-one relationship between the two tables. Microsoft Access 97 incorporates relationships as objects separate from tables, so you can design directly from Entity-Relationship diagrams.
Access also uses relationships to automatically generate joins between tables.
In this chapter of the tutorial, you can safely ignore relationships. Be sure the cursor is in the box in the Tables row immediately to the right of the Discontinued column. Press the button in the box to display the table choices. Select Suppliers . Selecting the Suppliers table Step 6.