To create the form, 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, ConWHSVehicleServiceTable.
- Drag the ConWHSVehicleServiceTable 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.
- Drag the ConWHSVehicleServiceLine table to the Data Sources node.
- Select the ConWHSVehicleServiceLine data source and set the Join Source property to ConWHSVehicleServiceTable.
We don't specify and join information beyond the name, as it will use the foreign key relation ...