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

Chapter 5. What Every Developer Needs to... > Basing Forms on Queries: The Why and...

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 bringing all fields and all records over the network, you bring only the fields and records you need. The benefits are even more 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. By basing a form on a query, 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 containing a one-to-many join, viewing parent and child information as if it were one record. Notice in Figure 5.41 that the client and project information appear on one form as if they were one record.

Figure 5.41. 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