Creating a details transaction (order entry) form

These worksheet forms are the most complicated in terms of the steps required, as we now have three states to design: list, header, and lines views. To familiarize yourself with the end result, open and use the All purchase orders form from Accounts Payable | Purchase orders | All purchase orders.

The first part of the pattern is very similar to the Details Master pattern, so we will summarize slightly. We will continue the vehicle service order table, but again, the recipe is written so that it can be applied to any worksheet table.

How to do it...

To create the form, follow these steps:

1. Choose to add a new item to the project.
2. Select User Interface from the left-hand pane and Form from the right-hand pane.
3. Name the form as per the table's name; in this case, ConWHSVehicleServiceTable.
4. Drag the ConWHSVehicleServiceTable table from the project onto the Data Sources node of the form designer.
5. Select the ConWHSVehicleServiceTable data source and set...