This bobblehead database shows you an example of a relationship. The telltale sign of a relationship is two tables with matching fields. In this case, the tip-off’s the Manufacturer field, which exists in both the Dolls table and the Manufacturers table.
Note: In this example, the fields that link the two tables have the same name in both tables: Manufacturer. However, you don’t have to do it this way. You can give these fields different names, so long as they have the same data type.
Using these linked fields, you can start with a record in one table and look up related information in the other. Here’s how it works:
-
Starting at the Dolls table, pick a doll that interests you (let’s say Yoda). You can find out more information about the manufacturer of the Yoda doll by looking up “MagicPlastic” in the Manufacturers table.
-
Starting at the Manufacturers table, pick a manufacturer (say, Rebobblicans). You can now search for all the products made by that manufacturer by searching for “Rebobblicans” in the Dolls table.
In other words, a relationship gives you the flexibility to ask more questions about your data, and get better answers.
Popularity: 1% [?]
Recent Comments