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

How to do it...

To implement table inheritance, follow these steps:

1. Open the ConVMSVehicleTable table and locate the Support inheritance property.
2. Change the property value from No to Yes. This will automatically create a new field called InstanceRelationType.

This field is used to select the various subtypes of a record. Therefore, we need to add an index to this table. Even though this logically replaces the need to have a vehicle type field, the vehicle type field is useful and should also have an index.

3. Create two indexes that allow duplicates, one for InstanceRelationType and the other for VehicleType. The name of the index should be the field name suffixed with Idx, for example, InstanceRelationTypeIdx.
4. As a side task, save all ...