Page 4 of 10PREVNEXT

Build relationships for a new Access 2007 database


So let's create a one-to-many relationship between the Suppliers and Assets tables. Before you start, think of the relationship as having "sides." In this case, one supplier can provide many assets, so the Suppliers table resides on the "one" side of the relationship, while the Assets table sits on the "many" side.

Next, remember this rule: To create a one-to-many relationship, you use the primary key from the "one" side as a foreign key on the "many" side. One of the easiest ways to do this is to run a tool called the Lookup Wizard. The wizard creates the relationship and the foreign key field. What's more, the foreign key works as a drop-down list, so you can select data from the table on the "one" side quickly and accurately. For example, when you enter data for a new asset, you can easily select the supplier.

The animation above shows you how to run the Lookup Wizard and create a relationship. Click Play to start it, and then try it yourself in the practice.

Page 4 of 10PREVNEXT