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

Hour 16. Power Form Techniques > Building Forms Based on More Than One Table

Building Forms Based on More Than One Table

Many forms are based on more than one table; such forms are called one-to-many forms. For example, a form that shows a customer at the top and the orders associated with that customer at the bottom is considered a one-to-many form. Forms can also be based on a query that joins more than one table. Rather than see a one-to-many relationship in such a form, you see the two tables displayed as one, with each record on the “many” side of the relationship appearing with its parent's data.


Creating One-to-Many Forms

There are several ways to create one-to-many forms. As with many other types of forms, you can use a wizard to help you or you can build the form from scratch. Because all the methods for creating a form are helpful to users and developers alike, the available options are covered in the following sections.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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