By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,454 Members | 2,633 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,454 IT Pros & Developers. It's quick & easy.

How to show...

P: n/a
Hello all,

I'm on work experience for my education, and I need to make a database
in Access 2003.
This database has to include all the information about the computers:
How many, the software, the hardware ect.

Now I'm kinda stuck at this part where I need to show which computer
runs certain software.

For example:
Classroom X has got 20 computers, and I wanna know where Adobe Reader
on these 20 computers is installed. I'm using Forms, because it looks
good for the one who's gonna work with it.
Now if I click on Adobe Reader in the selection of Software, it should
highlight (or whatever) the computers where it's installed. My current
and only option is to make a table for each computer, but that's not
actually a good option, because when I add a new computer I have to add
a new table and edit the Form and all. That's too complicated.

So anyone got an idea how to make this work?
Thanks in Advance

Rob

May 18 '06 #1
Share this Question
Share on Google+
10 Replies


P: n/a
you have a table with computers and a table with software.

computers (id,name)
software (id,name)

you have a table connecting computers with software:

comsoft (soft_id,comp_id)

now you can query all software on a specific computer. is this
answering your question?

May 18 '06 #2

P: n/a
Hi Rob

I'm currently in the process of making an inventory system although my
inventory will use multiple table for recording machine specifics,

Currently my database collects the data from the system using a unique key
as all our computer names are the asset number (e.g AN003344) of the machine
and there is never two asset numbers the same i use this as the primary key
for the system and and it is tagged onto the software list from the PC
therefore creating the link between the two.
I have two tables
Computers(AssetNo, CPU, MEMORY etc)
Sotware(AssetNo, SoftwareTitle etc)

Then you could create the relationship as a one to many in a query from the
SystemID on the PC table to the SystemID on the Software table.

I did have some code that based on what was selected it would filter the
records on the form and show only the records that matched your criteria

Regards

Aaron

"RobK" <ik*******@hotmail.com> wrote in message
news:11*********************@i39g2000cwa.googlegro ups.com...
Hello all,

I'm on work experience for my education, and I need to make a database
in Access 2003.
This database has to include all the information about the computers:
How many, the software, the hardware ect.

Now I'm kinda stuck at this part where I need to show which computer
runs certain software.

For example:
Classroom X has got 20 computers, and I wanna know where Adobe Reader
on these 20 computers is installed. I'm using Forms, because it looks
good for the one who's gonna work with it.
Now if I click on Adobe Reader in the selection of Software, it should
highlight (or whatever) the computers where it's installed. My current
and only option is to make a table for each computer, but that's not
actually a good option, because when I add a new computer I have to add
a new table and edit the Form and all. That's too complicated.

So anyone got an idea how to make this work?
Thanks in Advance

Rob

May 18 '06 #3

P: n/a
it has to be both ways: Show allo software on a specific computer, and
show all computer with specific software.

May 19 '06 #4

P: n/a
The problem is, I cannot make relations between computers and software
because it's saying that the records are not related to eachother.

May 19 '06 #5

P: n/a
Allright I made some screenshots to show you what I currently have, and
what I actually want.

This is what I have:
http://img234.imageshack.us/my.php?i...entform8oc.jpg

This is what I want:
http://img138.imageshack.us/my.php?i...ultform4ei.jpg

May 19 '06 #6

P: n/a
Sorry, the part where it says that the computers are tables, should be
fields.

My apologies for the spamming =P

May 19 '06 #7

P: n/a
My apologies, the picture is saying the computers are all tables, but
they're not. The computers are fields. I have put the computers in one
table, and I've put the software in another table.

Making relations does not solve the problem, because it doesn't allow
me to make relations between the two tables at all cuz it says the
records aren't related to eachother (totally different records)

So even though it's a good idea, I'm still stuck at that point =P

May 19 '06 #8

P: n/a
"RobK" <ik*******@hotmail.com> wrote in
news:11**********************@y43g2000cwc.googlegr oups.com:
My apologies, the picture is saying the computers are all
tables, but they're not. The computers are fields. I have put
the computers in one table, and I've put the software in
another table.

Making relations does not solve the problem, because it
doesn't allow me to make relations between the two tables at
all cuz it says the records aren't related to eachother
(totally different records)

So even though it's a good idea, I'm still stuck at that point
=P

Somebody already posted the answer, but you missed it or
misunderstood it..

What you need is a third table, SoftwareOnComputer

This table contains two fields, the computer ID and the software
id. In your query, you relate the computer table to the
SoftwareOnComputer table via the Computerid, and also relate the
software table to the SoftwareOnComputer table, via the
softwareID.

This method is very common.
Google for the term "Many to Many Database Relation"
here a result from that search
http://www.databasedev.co.uk/many_to_many_example.html

--
Bob Quintal

PA is y I've altered my email address.
May 19 '06 #9

P: n/a
Yes, I believe I kind of misunderstood.
The only downside of the solution is that I have to make it for 100
applications on 150 computers, so it's gonna cost me alot of time.

Thank you all for the great help and support. Very much appreciated!

May 22 '06 #10

P: n/a
"RobK" <ik*******@hotmail.com> wrote in
news:11*********************@j33g2000cwa.googlegro ups.com:
Yes, I believe I kind of misunderstood.
The only downside of the solution is that I have to make it
for 100 applications on 150 computers, so it's gonna cost me
alot of time.

Thank you all for the great help and support. Very much
appreciated!

A good data-entry form would cut down the time a lot.

I do it by creating an unbound form,with a combobox at the top
holding the computerID;ComputerName. column width width 0";2".
I'd have a listbox with softwareId;SoftwareName on the right,
running down the form, as long as possible. Ther would be a
subform on the left, which contains the results of selecting a
computer and double-clicking on the software. This is linked
parent-child to the combobox.

The on-Doubleclick code creates the new record, requeries the
subform, then requeries the listbox to exclude software already
associated with the computer selected in the combobox.

--
Bob Quintal

PA is y I've altered my email address.
May 22 '06 #11

This discussion thread is closed

Replies have been disabled for this discussion.