Creating order line tables

This recipe continues from the previous order header table recipe. The example in this recipe is that we will have service order lines that reflect the work required on the vehicle. The concepts in this recipe can be applied to any order line table; to follow exactly, the previous recipes should be completed first.

How to do it...

To create the order line table, follow these steps:

1. Create a new table named ConWHSVehicleServiceLine.
2. Drag the following EDTs onto the table:
   • ConWHSVehicleServiceId
   • LineNum
   • ItemId (you may receive an error if you haven't referenced Application Suite)
   • ItemName
   • ConWHSVehicleServiceStatus

3. Remove the ConWHSVehicle prefixes.
4. The ServiceId and LineNum fields are usually controlled from code, so make them...