Hey all,
Gone in a bit over my head with an access project at work, I'm sure I knew all this stuff when I was doing my dissertation. You guys helped me big time back then. Anyway...
The three tables concerned with this are "hardware", "software" and "hardware_software", any one hardware record can have multiple related software records, depending on what is installed on that particular (in this case) computer. This info is stored in a joining table called "hardware_software", which also records install date and method.
So, normally I install software per room, out biggest having 26 PCs. Is there a way of looking up my software and hardware record and then adding the corresponding records in hardware_software to a group of hardware records, depending on their "location" field?
Appreciate any pointers
Martin
Gone in a bit over my head with an access project at work, I'm sure I knew all this stuff when I was doing my dissertation. You guys helped me big time back then. Anyway...
The three tables concerned with this are "hardware", "software" and "hardware_software", any one hardware record can have multiple related software records, depending on what is installed on that particular (in this case) computer. This info is stored in a joining table called "hardware_software", which also records install date and method.
So, normally I install software per room, out biggest having 26 PCs. Is there a way of looking up my software and hardware record and then adding the corresponding records in hardware_software to a group of hardware records, depending on their "location" field?
Appreciate any pointers
Martin
