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

Linked Table Gotchas

The main gotcha with linked tables is that it is way too easy to accidentally bring much more data over the network wire than is required. This is most commonly caused when a form is based on a table or on a query that brings back all of the rows from a table. Ensuring that you provide the user with a means for selecting only the data that he needs in each form and then basing the form on that criteria eliminates most of the problems inherent with linked tables.

Another gotcha with linked tables involves connections. Multiple combo boxes on a form utilize multiple connections. Basing static combo boxes on local tables greatly reduces the number of connections that each user consumes, thereby making your application more scalable.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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