Simple Access Problem, please help

[msaesxh]

I need to make a very simple database to keep my boss happy, basically
I need to make a database that tells you a lab number, a type of
computer, and a bunch of different programs that are installed in the
lab. I made a table called programs that has every program that could
be installed in the lab, what I need to know how to do is take for
instance, 5 of these programs and assign them to say lab a. I don't
know if that explanation is good enough but please help me out. Thanks.

 

[Guest]

Hi

There is a little more to it than this but I how this will point you in the
right direction.

Create a table called [tblLab]
LabID = Primary Key (auto number)
LadName = Text.

In the table you have already made add a field called [LabID] (number
format) and in this field enter the LabID of the lab where the programme is
used. You could use a lookup field for this (but I know that loads of people
and MVP's will tell ou not to - but hey - give it a go and see what you think)

Open the relationships window and drag the LabID field (from tblLab) and
position it over the labID in your other table. Select referential
integrity. Save

Create a new form called Labs and bring in LabID and LabName (single form)

Create a new form called programmes and bring in LabID and Programmes (Data
sheet)

Open the Labs Form in Design and insert the Programmers form as a sub form.
Use LabID as the child and parent fields.

When you select a Lab in the main form the programmes for that lab will be
shown in the sub form.

Enjoy

 

[msaesxh]

Ok awesome, that helped out alot, thank you very much. Would you be
able to help me out with one more thing? I have a table that has about
100 computer programs, and instead of typing out 20 different programs
over and over for each lab, is there any way I can somehow take the
data out of the program table and have it show up in the installed
programs table? I think I may not be on the same page as you at this
very moment. Let me start all over. Ok, so what I had before you helped
me out was this (and obviously this is sort of wrong): a table called
Windows Programs, which simply had each program listed; a table called
Labs, which had each lab listed; and a table called Computers, which
had each computer listed (though that is not necessity right now). So,
what I want is to be able to click on say Lab A and see a list of 5
programs that are installed in Lab A. However, the tricky part is, I
need this list of programs to be 5 different pieces from the table
called Windows Programs, because I also need the list of programs to be
searchable by query. Now what you told me to do is what I need, it
shows me the lab and the programs installed, - but I am having issues
getting it to work properly. For instance, I can't seem to get more
than one piece of data when I, say, look at Lab A - I don't know how to
see the five pieces from the Windows Programs table - is that even
possible? Your the man if you continue to help me out, thanks alot.

 

[msaesxh]

Ok, I may have a solution, using the setup you gave me:

[LabID]-----------------subform----> [LabID]
Labname Windows Program

This works well, so, what I essentially want to do is set up the same
type of system used for the labs, for the programs, and I am thinking
something like this:

[ProgID]--------------subform----->[ProgID]
Programname Labname

Does this make sense? Now the other problem is this, can I just add in
LabID in the subform, so the ProgID will be related to many LabID's
(just as LabID was related to many Windows Programs in the originally
set up) and these LabID's will then connect with the Labname that will
appear in the subform?