Extending Microsoft Dynamics 365 Finance and Supply Chain Management Cookbook - Second Edition

How to do it...

We will first create the worksheet header table, which will be a vehicle service order table:

1. Create a new table named ConVMSVehicleServiceTable.
2. Create a primary key EDT, ConVMSVehicleServiceId; this time, extend Num. Complete the Label and Help Text properties with appropriate labels.

3. Drag the EDT from Solution Explorer to the Fields node of our table and rename it ServiceId.
4. Complete the ServiceId field as an ID field: Mandatory = Yes, Allow Edit = No, and Allow Edit On Create = Yes.
5. Complete the relation information on the ConVMSVehicleServiceId EDT.
6. Create the primary key index as ServiceIdx with ServiceId as the only field.
7. Set the Clustered Index and Primary Index properties as ServiceIdx.
8. Drag the ConVMSVehicleId ...