The following to define a product
Product, Colour, Size
The following to enter order, production and despatch on daily basis
Order, OrdersLine, Production, ProdLine, Despatch, DespLine
I have made the forms accordingly and being able to enter the data for daily orders, production and despatch in respective forms.
I need to create a report (which I am doing in excel, by manually deleting previous day's figures and entering today's figures), am enclosing a snapshot of the report from excel.
Can someone suggest how to create a report in a similar format.
Thanks in advance
- DPM-report