I am creating a database that will catalogue all of the computers at my office. It will also catalogue what software is installed IN them and what Software is installed ON them.
I am having no problems with the hardware side of things. The software is a different matter altogether!
I have a table called "PC Base Unit", "Software" and "LicenceTable".
As there are many software titles and many computers I have the link box "LicenceTable". The records in this table are dynamially generated using a script which adds as many rows per software title as there is in the "MaxLicenceNumber" field. This means that if we have 5 versions of MS Excel (with the ID MSE00) then the "LicenceID" field of the Licence table will have:
Licence ID | PC Asset Tag
MSE00-001 | GEN0101
MSE00-002 | ITS0100
MSE00-003 | other PC Id's
There is another field in this table which is used to link the LicenceTable to Software. That is the software ID.
Now, as i understand it in the Software field it should automatically put the PackageID value that the LicenceID value realates to, like this:
This then should allow me to run a query that will be able to determine the name and version (stored in the software table) of the software on each computer eg.
On GEN0100 - Microsoft Excel 2000.
This is not happening! When I open the LicenceTable I have the generated (using INSERT INTO) LicenceID and whichever PC ID numbers I have entered into the PCAssetTag field. But the PackageID field is empty.
I cannot work out what the problem is... can any of you fine people help??
I only put the Package ID field into the Licence table so that I could link them together. The link appears and I enforce referential integrity, however when I try a query as you suggested it gives me no results when I know that there should be.