Welcome to SPN

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

Sign Up Now!

Lookup Table

Discussion in 'Information Technology' started by wycats@gmail.com, Nov 15, 2005.

Tags:
  1. wycats@gmail.com

    wycats@gmail.com
    Expand Collapse
    Guest

    I have three tables:

    Requests: Stores data about maintenance requests
    Categories: List of maintenance categories (i.e. mold, plumbing, etc.)
    AssignedTo: List of people who maintenance requests can be assigned to

    Each request has a category, and each person in AssignedTo has a
    category.
    The requests table contains a field for AssignedTo.

    I'm trying to set up a lookup so that once a category is selected in
    the Requests table, only AssignedTo's with the same category as the
    category of the request itself will show up on the list. I tried to do
    some queries, but I can't figure out a way to reference the current
    record in a query.

    Any thoughts?
     
  2. Loading...

    Similar Threads Forum Date
    As A Child, Public Marches Of Sikhism Made Me Uncomfortable. They Still Do . Why ? Whats The Logic Hard Talk Oct 16, 2016
    Arts/Society Backyard Vegetable Garden Language, Arts & Culture Dec 27, 2013
    Heritage Now a Vegetable Market, Ranjit Singh's Royal Haveli a Picture of Neglect History of Sikhism Nov 11, 2013
    Sikhism Helium: 1984 and the "Periodic Table of Hate" (Jaspreet Singh) Book Reviews & Editorials Oct 28, 2013
    Heritage How our entire history was dumped in a horse stable History of Sikhism Oct 28, 2013

  3. SusanV

    SusanV
    Expand Collapse
    Guest

    Are you using a form? If so reference it as Me.Control where Control = the
    name of the dropdown box for Requests. Truthfully, the best way is to use
    cascading comboboxes:
    http://www.fontstuff.com/access/acctut10.htm
    --
    hth,
    SusanV


    <wycats@gmail.com> wrote in message
    news:1131990203.338401.28990@g44g2000cwa.googlegroups.com...
    >I have three tables:
    >
    > Requests: Stores data about maintenance requests
    > Categories: List of maintenance categories (i.e. mold, plumbing, etc.)
    > AssignedTo: List of people who maintenance requests can be assigned to
    >
    > Each request has a category, and each person in AssignedTo has a
    > category.
    > The requests table contains a field for AssignedTo.
    >
    > I'm trying to set up a lookup so that once a category is selected in
    > the Requests table, only AssignedTo's with the same category as the
    > category of the request itself will show up on the list. I tried to do
    > some queries, but I can't figure out a way to reference the current
    > record in a query.
    >
    > Any thoughts?
    >
     

Share This Page