Hi, i'm creating an Inventory database to record hardware components of computers in an office, the database allows you to add multiple HDD, cd drives, peripherals etc but when it comes to doing a report on specific computers it shows reports for each combination of multiple hardware devices, if anyone has any ideas can you please email me at watoom@hotmail.com and i can send you a copy of my database to look at.
Cheers
Garth

Sounds like you have created separate tables to hold different types of components. A better design would store them all in the same table with a code indicating component type.

To build a report for what you have, you will need to use subreports for each separate table. So, the main report is based off the computer table, sub1 is for hard drives, sub2 is for cd drives, etc.

The problem you are seeing occurs because although each of the "sub" tables is related to the computer table, they are not related to each other. So, if you have 1 computer with 2 HDD's, 2 CD's, and 2 printers you end up with 1 x 2 x 2 x 2 = 8 records.