Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Simple Access Problem, please help

Discussion in 'Information Technology' started by msaesxh, Jul 28, 2006.

  1. msaesxh

    msaesxh
    Expand Collapse
    Guest

    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.
     
  2. Loading...

    Similar Threads Forum Date
    Grammer / Vyakarn Learn Simple & Easiest Gurbani Vyakaran/grammer From Prof. Maninderpal Singh Language, Arts & Culture Mar 9, 2015
    General Babaji Ranjit Singh Dhandrian Wale, Simple living high Thinking Hard Talk Sep 27, 2013
    Sikh Weddings Simple? No, they Are Indulged In Brahmanwad Questions and Answers Sep 15, 2012
    The One-Minute Mystic: Simple Things You Can Do to Stay Connected Spiritual Articles May 23, 2011
    Being a Simple Sikh (blog of a Prithihardkaur Sikh) Spiritual Articles Sep 13, 2010

  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    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

    --
    Wayne
    Manchester, England.



    "msaesxh" wrote:

    > 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.
    >
    >
     
  4. msaesxh

    msaesxh
    Expand Collapse
    Guest

    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.
     
  5. msaesxh

    msaesxh
    Expand Collapse
    Guest

    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?
     

Share This Page