Search results

Thanks, its working now. It is pretty simple but I would have never worked that out myself :)

Yeah that's how far I got myself by now by looking at your sample databases. What I can't figure out how I can get the SoftwareID field to display the SoftwareName instead of the ID. This is probably quite simple but I just can't figure it out :confused: Thanks for your help!

Thanks for the answers, I get the idea but I am still making a mistake somewhere as I can't get it to work. These are three tables involved: tblPCHardware -PCID -CPUType -etc. tblSoftware -SoftwareID -SoftwareName tblPCHardwareToSoftware -SoftwareID -PCID and the following query...

Many-to-many relationship between main form and subform? I am working on a database to keep track of the hardware and the software inventory of the company I work for. I've got a table for the PCs and a table for the software. These two have a many-to-many relationship via another table (b/c a...

Thanks! I should have been able to figure that out myself...

My initial explanation of the problem probably wasn't all that good. ;) I am not really sure how I am supposed to implement your answer (I am still pretty much an Access newbie). If I put the "WHERE OperatingSystem = True" in the criteria field of the "OperatingSystem" column and ten run the...

I don't think they are seperate entities. Operating systems just like any other software is installed on computers and needs a license to be used. Whether a software is an OS or not is just one its properties. If I wanted relationships between software and operating systems then I would have to...

Thanks for the quick reply :) I thought of that as well but the problem is that the software table is in turn linked to the software license table which makes it a bit complicated to have separate operating systems and software tables. I need this query for a dropdownbox that should only...

I am working on a software and hardware inventory database for my company. I have all the software stored in one table that basically looks like this SoftwareID AutoNumber SoftwareName Text OperatingSystem? Boolean I need a query that only returns the names of all...

That is what I wanted to do but my "boss" wants me to do it in seperate tables so that they can later on add extra tables for telephones etc.

Hi, I am working on a database of the inventory of PC-Hardware and Software. The hardware is basically divided into PCs and Displays both of which will have a seperate table. Each PC and each Display should have an InventoryID (which Access will automatically assign) but an InventoryID may only...