Creating order header tables

Order and line tables are used whenever we need a worksheet to enter data that is later acted upon. Once they have been processed, they should no longer be required. Reports should act upon the transactions that the order created, such as inventory transactions, sales ledger transactions, invoices, and more.

Getting ready

Although we will be using the tables created earlier, the pattern can be followed with your own solution.

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 ConWHSVehicleServiceTable.
2. Create a primary key EDT, ConWHSVehicleServiceId; 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 to ServiceId.
4. Complete the ServiceId field as an ID field: Mandatory = Yes, Allow Edit = No, Allow Edit On Create = Yes.
5. Complete the relation information on the EDT...