Welcome to SPN

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

Sign Up Now!

Looking up data in Access 2000

Discussion in 'Information Technology' started by Jennifer Portnick, Nov 14, 2005.

Tags:
  1. Jennifer Portnick

    Jennifer Portnick
    Expand Collapse
    Guest

    Hello-

    I'm quite new to working with Access (as this message may give away).
    I've created a simple database for my company with the following
    tables:

    1. Store location number, store name and store address;
    2. Staff assignments by store (names of support personnel assigned to
    each store location).

    I have created relationships between these two tables based on store
    number and my query will pull a datasheet listing staff for each store.
    What I'd also like to do, though, is have a form in which if I put a
    store name, the store number, name, address, and staff assigned come
    up. I think this is done using a combo box but for the life of me I
    can't figure out how to do it. Can anyone offer some guidance?

    Thanks-
    Jennifer P.
    San Francisco, CA
     
  2. Loading...


  3. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    Jennifer

    From your description (one-to-many, store-to-employees), you could use a
    mainform/subform construction. Your main form could use a combo box to let
    you pick a store, then display that store's data. The subform would be
    "fed" by a list of employees, including their StoreID (which store(s) they
    work at).

    When you add (in form design mode) the subform into the mainform, Access
    prompts for the parent-child fields. I'm guessing that's StoreID?!

    Best of luck on your project.

    --
    Regards

    Jeff Boyce
    <Office/Access MVP>

    "Jennifer Portnick" <jportnick@yahoo.com> wrote in message
    news:1131917476.689158.185810@g47g2000cwa.googlegroups.com...
    > Hello-
    >
    > I'm quite new to working with Access (as this message may give away).
    > I've created a simple database for my company with the following
    > tables:
    >
    > 1. Store location number, store name and store address;
    > 2. Staff assignments by store (names of support personnel assigned to
    > each store location).
    >
    > I have created relationships between these two tables based on store
    > number and my query will pull a datasheet listing staff for each store.
    > What I'd also like to do, though, is have a form in which if I put a
    > store name, the store number, name, address, and staff assigned come
    > up. I think this is done using a combo box but for the life of me I
    > can't figure out how to do it. Can anyone offer some guidance?
    >
    > Thanks-
    > Jennifer P.
    > San Francisco, CA
    >
     
  4. Jennifer Portnick

    Jennifer Portnick
    Expand Collapse
    Guest

    I'll give this a try. Thank you very much for your response.
     

Share This Page