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

Chapter 11. Developing an MDB Client/Ser... > Building Client/Server–Friendly Form...

Building Client/Server–Friendly Forms

The goal of a client/server application is to reduce the amount of data that travels over the network wire. This involves carefully designing your forms and reports to ensure that only the required data is retrieved. An overview of the steps required to build such a client/server application using linked tables includes the following:

1.
Link to the tables contained in the SQL Server database.

2.
Build a tabbed form that will contain Customer, Order, and Order Detail tabs.

3.
Add a combo box to the form that allows the user to locate data for a specific company.

4.
Create a query that is used to populate the detail section of the form. The query retrieves data only for the selected customer.

5.
Create a query that is used to populate the detail section of the order subform.

6.
Create a query that is used to populate the detail section of the order details subform.

7.
Hide the order and order detail subforms until the appropriate tab is selected.

8.
Specify blank record sources for the subforms.

9.
Designate the record source for the subforms, and make the subforms visible only when the appropriate tab is selected.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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