AnsweredAssumed Answered

Complex report assistance

Question asked by Peter_2 on Jan 5, 2014
Latest reply on Jan 6, 2014 by Peter_2


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?