In this chapter
Learn how to add lookup fields to your tables
Run the Table Analyzer to get hints on making your design more efficient
Create and modify relationships between tables
Use referential integrity to protect your data
The average person might define the term relationship as a connection of blood or marriage. In the relational database world, the term relationship simply refers to an association between two records. That’s the good news—you don’t have to send your Access database flowers when you mess up. The bad news is that you might find Access relationships just as frustrating as your blood relations. An irate mother-in-law has nothing on an Access relationship run amuck.
The truth is that ...