Help with design for inventory?

[Guest]

I want to creat a db to track two items: (1) the various software Apps
installed on a PC and, (2) info about each software App...software name,
serial number, price, install date, etc. I created one table with Software
ID, Software Name, serail number etc. I created another table with all the
PCs listed. How can I create a table to allow me to check off "each software
listed on a PC?"

 

[Guest]

You need a third installation record table. This table is a transitionary
table that links a intstallation ID with a softwar app ID and on the other
table a PC ID.

You could then use an yes/no field and a notes field to track if a
particular software is installed on a particular computer.