O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

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

Synchronized Subforms

Subforms are used to illustrate one-to-many relationships in forms. The main form and the subform are synchronized, which means that when you switch records in the main form, the subform displays the corresponding records for the “many” relationship. Figure 10-20 shows a form that displays product data. The subform displays the monthly sales figures for the respective product.

Figure 10-20. Form with subform

The subform’s control element properties Link Child Fields and Link Master Fields define the relationship between the main form and the subform, as displayed in Figure 10-21.

Figure 10-21. Properties of the subform ...

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