I believe you go into the relationships section, or in the query, wherever you've defined the relationship... double click on the link and change it from a one to one relationship to a one to many. The query should automatically repeat the rows with different data for the hard drives in them.
I am creating a report in Microsoft Access that links back to the Spiceworks database.
For my example, I have linked the devices and disks tables with the 'id' field. I'm trying to create a report that will show me all the disks with the assigned id which is being reported against (essentially, it is using the devices table as the master table to report against).
How can I insert a field on my report that shows me every disk that is assigned to the computer name or id in that particular report section?