Introduction

This tutorial will teach you how to build the "SDP_Orders" application. It assumes you have completed the previous tutorials and are familiar with creating forms and controls and setting their properties.

This is an important section as it provides you with vital information about creating and using SubForms, and handling relationship between tables. For a detailed explanation of Form and SubForms, please refer to the Glossary.

Tables and Forms

The SDP_Orders application is composed of four tables and two forms. The tables are:

• Customers
• Order Details
• Orders
• Products

You will be able to edit the the Customer records by using the SDP_OrdersCustomer. The SDP_Orders form allows you to add, delete, and edit the order details and produce an order summary by product.

SubForm and Domain Functions

Abstract: A SubForm is a collection of controls that have an alternative record source that can be related to the record source of the main Form, i.e. the "Parent" form.

This tutorial demonstrates how to create and use SubForms and Domain functions. These are possibly the most difficult aspects of SprintDB Pro; however, once you understand them, you will find them extremely useful.

Click the Next button, below, to continue...

The 'Customer' Form. Created using the Default Form function.

The 'Customer' tab controls.

The 'OrderDetail' tab controls.

The 'by Product' tab controls.