You might want to begin deciding what is missing from your table(s) and the structures of those tables.
You should have a table defining the computers you are monitoring. This table has nothing to do with software. It contains information about your computers. You will need to determine a unique attribute per computer or an autonumber, to define a primary key for your computer table.
You also have a table of software that has nothing to do with your computer table. Each record on your software table reflects one software product. Example, Operating system software (XP, NT, WIN20000, etc), Application tool software, (Database, Word Processing, Spreadsheet,etc).
Now, to begin bringing this together you need something called a juncture table. In this instance, each juncture record contains two fields. The first field is the primary key of your computer table and the second field contains the primary key of your software table. So, assuming that your computer with a primary key of 1, I is running only NT, EXCEL. AND WORD. So, on your juncture table you can find all software running on any computer for looking for a match on the primary key of the computer, and reading the corresponding software id from the second field,
Looking at the software side, we can find every computer using a particular software type, which should show you how to do what you are attempting to do.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com