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.
Creating order header tables
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:
- Create a new table named ConWHSVehicleServiceTable...
