• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 19. Taking Advantage of Database... > Creating Multi-Table Forms

Creating Multi-Table Forms

Forms can be created from more than one table using the Form Wizard or the Form Design view. Creating a form from fields that reside in more than one table allows you to enter data into more than one table using just the single form.

A very simple way to create a multi-table form is to add a subform to an existing form. For example, you might have a form that is based on a Customers table. If you would also like to be able to view and enter order information when you work with the Customers form, you can add an Orders subform to it. It is important that the tables used to create the two forms (the main form and the subform) are related tables.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint