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 read-only and mandatory (this ensures that the code that sets them has run before the user saves the line).

Note

The LineNum field is usually used to order the lines and can be made not visible if this isn't to be displayed in the user interface. All visible...