APPENDIX A

In chapter 3 we created simple forms for single tables. A very useful form is one where the user can interact with data that comes from more than one table. We will consider how this can be done in cases where two tables are related by a one-to-many relationship.

We will illustrate creating such a form using the form wizard. As you will see the form wizard will create a form and a subform. These two forms will have a connection established based on related fields: a primary key and a foreign key.