Defining Relationships
After you have defined two or more related tables, you should tell Microsoft Access how the tables are related. You do this so that Access will be able to link all your tables when you need to use them in queries, forms, data access pages, or reports.
Thus far in this chapter, you have seen how to build the main subject tables of the Contact Tracking database—Companies, Contacts, and Products. Before we define the relationships in the sample database you’ve been building, you need to create a couple of linking tables that define the many-to-many relationships between Companies and Contacts and between Products and Contacts. Table 4-9 on the next page shows you the fields you need for the Company Contacts table that forms ...
Get Microsoft® Office Access 2003 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
