O'Reilly logo

Microsoft® Office Access 2003 Inside Out by John L. Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required