We will first create the worksheet header table, which will be a vehicle service order table:
- Create a new table named ConWHSVehicleServiceTable.
- Create a primary key EDT, ConWHSVehicleServiceId; this time, extend Num. Complete the Label and Help Text properties with appropriate labels.
- Drag the EDT from Solution Explorer to the Fields node of our table, and rename it to ServiceId.
- Complete the ServiceId field as an ID field: Mandatory = Yes, Allow Edit = No, Allow Edit On Create = Yes.
- Complete the relation information on the EDT.
- Create the primary key index as ServiceIdx with ServiceId as the only field.
- Set the Clustered Index and Primary Index properties as ServiceIdx.
- Drag the ConWHSVehicleId EDT to our table and rename ...