Complex report assistance
I am currently creating an orders database for equipment that is sent to customers for them to build themselves. I have created 6 tables: Sites (customer site info), Orders , OrderLine, Assembly, AssemblyLine & Components. Customers order the equipment (the assemblies) & the assemblies are made up of a number of components. The equipment/assemblies can be delivered over a number of dates - hence the Phase No/Delivery date in orderline.
What I want to do is to provide a report to our transport people which lists all the equipment broken down into components by delivery date/phase.
The full database will have more fields but before I add them I want to make sure that the structure I have created can do what I need it to, and I am struggling at creating the report.
What I would like to know is, can such a structure deliver such a report, or do I need to go back to the drawing board & re-structure my database?