To create the details master form, please follow these steps:
- Choose to add a new item to the project.
- Select User Interface from the left-hand pane and Form from the right-hand pane.
- Name the form as per the table's name; in this case, ConWHSVehicleTable.
- Drag the ConWHSVehicleTable table from the project onto the Data Sources node of the form designer.
- Select the ConWHSVehicleServiceTable data source and set the Insert If Empty and Insert At End properties to No.
Insert If Empty will create a new record if there are no records, which is undesirable for main table and order header tables. The Insert At End property can also be undesirable; if the user presses the down arrow key on the last record, a new empty record ...