Microsoft® Office Access 2003 Inside Out

Defining Relationships

Now that you have learned how to build tables in an Access project, you can start defining relationships between them. As you learned in Chapter 3 and Chapter 4, defining relationships is valuable because it enforces referential integrity between the tables. It also makes building queries and forms on those tables easier. The same is true in an Access project linked to SQL Server.

Defining Relationships in Table Design View

After you’ve built the tables, you’re ready to start defining relationships. In an Access project, you can define a relationship in Design view. All you need are two tables—one that has a primary key and another that contains a related foreign key. Open the CompanyContacts table in Design view, right-click ...