Listing the software on each piece of equipment

[ConnorLally]

Hi



So I am in the midst of creating my very first Access database at work. I have been asked to create a database to keep track of our IT assets. I have my equipment table, which lists the type of equipment (laptop, desktop etc), the make, model, serial number and all that. I have a software table which tells me the software name and the current version we are using. To create the relationship between these two tables I have created a link table, as each piece of equipment can have many pieces of software installed, and each piece of software can be installed on multiple pieces of equipment. So I used a junction table to create the many-to-many relationship. I have created a query that shows each time a piece of software has been added to a piece of equipment. However, it keeps repeating the equipment information each time a new piece of software has been added, so it looks like this for example:

Make Model Serial Number Software Version
HP Probook CNU4T1Y0XF Microsoft Office 2010
HP Probook CNU4T1Y0XF Sage 200 8.0.2

And so on and so forth

I was wondering if it was possible to set it up so that I simply search for one piece of equipment and then it lists all of the software that has been linked to it?

Thanks in advance for any help given

[June7]

Don't really understand the issue. The query is behaving normally.

Apply filter criteria to the query.

[ConnorLally]

Sorry I was unclear, I'm not saying that the query isn't working, I was just wondering how to apply the filter to work in the way that I want it to?

I'm new to Access so I'm still trying to get the hang of things

[June7]

You could directly type the specific serial number you want to search for on the Criteria row under the Serial Number field.

Other options:

http://www.datapigtechnologies.com/f...earchform.html
http://www.datapigtechnologies.com/f...tomfilter.html
http://www.datapigtechnologies.com/f...mtoreport.html
http://allenbrowne.com/ser-62code.html


BTW, advise not to use spaces and special characters/punctuation (underscore is exception) in naming convention.