Im having a really annoying problem with reports, can someone please help me.
I have an Order table in which OrderID is my PK.
The Order table is linked to a MaterialsOrder table through the OrderID as a FK.
The Order table is also linked to the ManpowerOrder table, again through the OrderID as a FK.
I’m using the report wizard to create the report to show the order with materials and manpower that are linked to it.
However it seems that when I do this, the same materials are listed again with each occurrence of manpower ordered.
All I want is the list of man power and list of materials.
How can this be achieved? I hope someone can help.
Sounds like you need to group on order and sum the materials and man power, but I seriously doubt you'll get there using the form/report wizards unless you get a query to give you the right data first.