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 ... |
Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
