O'Reilly logo

Microsoft® Office Access 2003 Step by Step by Online Training Solutions Inc.

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

Adding a Subform to a Form

Adding a Subform to a Form

A form can display information (fields) from one or more tables or queries. If you want to display fields from several tables or queries in one form, you have to give some thought to the relationships that must exist between those objects.

In Access, a relationship is an association between common fields in two tables, and you can use it to relate the information in one table to the information in another table. For example, in the GardenCo database a relationship can be established between the Categories table and the Products table because both tables have a CategoryID field. Each product is in only one category, but ...

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