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

Hour 16. Power Form Techniques > Basing Forms on Queries: The Why and How

Basing Forms on Queries: The Why and How

One strategy when building forms is to base them on queries. By doing this, you generally get optimal performance and flexibility. Rather than bring all fields and all records over the network, you bring only the fields and records you need. The benefits of doing this are especially pronounced in a client/server environment where the query is run on the server. Even in an environment where data is stored in the proprietary Access file format (.mdb) on a file server, a form based on a stored query can take better advantage of Access's indexing and paging features than a form based on a table. By basing a form on a query rather than a table, you also have more control over which records are included in the form and in what order they appear. Finally, you can base a form on a query that contains a one-to-many join and view parent and child information as if it were one record. Notice in Figure 16.20 that the customer and order information appear on one form as if they were one record.

Figure 16.20. A form based on a one-to-many query.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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