Welcome to SPN

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

Sign Up Now!

Combo box riddle

Discussion in 'Information Technology' started by Will, Nov 1, 2005.

Tags:
  1. Will

    Will
    Expand Collapse
    Guest

    We are having trouble getting all of this to tie together properly...
    Maybe someone would be kind enough to grind through the below and give us
    some help.

    Given table structures like...

    - tblA relates to tblB relates to tblC - (A:B is a One:Many --C:B is a
    One:Many)
    - tblA relates to tblX - (A:X is a One:Many)
    - Now we have a field in tblB that we want to popuulate with the value from
    a field in tblX.
    - We would like to use a Combo Box to do this.
    - The values the combox box presents must have its idA = to the idA in the
    tblX record.

    So we may have...
    tblA with fields idA, A1, A2, ect
    tblB with fields idB, idA, idC, B1, B2, etc
    tblC with fields idC, C1, C2, etc.
    tblX with fields idX, X1, X2, etc

    for tblA.idA = 1 we will have several records in tblB
    for tblA.idA = 1 we will have several records in tblX
    we want the combo box for populating X1 to choose from the values in B1
    where tblB.idA=tblX.idA

    And we are trying to do all of this on a single form with subforms.
    - tblA is populated on the form
    - related tblB records are created and populated on the form or subform
    - related tblX records are ceated and populated on the form or subform

    thanks for any help on all this.
     
  2. Loading...


  3. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    Will

    Given that you already have the relationships between tblA and tblX, and
    between tblA and tblB, why are you trying to (?redundantly) store a value
    from tblX in tblB?

    --
    Regards

    Jeff Boyce
    <Office/Access MVP>

    "Will" <Will@somewhere.com> wrote in message
    news:Txm9f.222777$p_1.2461@tornado.tampabay.rr.com...
    > We are having trouble getting all of this to tie together properly...
    > Maybe someone would be kind enough to grind through the below and give us
    > some help.
    >
    > Given table structures like...
    >
    > - tblA relates to tblB relates to tblC - (A:B is a One:Many --C:B is a
    > One:Many)
    > - tblA relates to tblX - (A:X is a One:Many)
    > - Now we have a field in tblB that we want to popuulate with the value

    from
    > a field in tblX.
    > - We would like to use a Combo Box to do this.
    > - The values the combox box presents must have its idA = to the idA in the
    > tblX record.
    >
    > So we may have...
    > tblA with fields idA, A1, A2, ect
    > tblB with fields idB, idA, idC, B1, B2, etc
    > tblC with fields idC, C1, C2, etc.
    > tblX with fields idX, X1, X2, etc
    >
    > for tblA.idA = 1 we will have several records in tblB
    > for tblA.idA = 1 we will have several records in tblX
    > we want the combo box for populating X1 to choose from the values in B1
    > where tblB.idA=tblX.idA
    >
    > And we are trying to do all of this on a single form with subforms.
    > - tblA is populated on the form
    > - related tblB records are created and populated on the form or subform
    > - related tblX records are ceated and populated on the form or subform
    >
    > thanks for any help on all this.
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
     
  4. Will

    Will
    Expand Collapse
    Guest

    Jeff,

    I think I mis-stated the question. I will repost later when I can more
    accurately articulate the issue.

    thanks,


    "Jeff Boyce" <JeffBoyce_IF@msn.com-DISCARD_HYPHEN_TO_END> wrote in message
    news:%23NRZSzh3FHA.632@TK2MSFTNGP10.phx.gbl...
    > Will
    >
    > Given that you already have the relationships between tblA and tblX, and
    > between tblA and tblB, why are you trying to (?redundantly) store a value
    > from tblX in tblB?
    >
    > --
    > Regards
    >
    > Jeff Boyce
    > <Office/Access MVP>
    >
    > "Will" <Will@somewhere.com> wrote in message
    > news:Txm9f.222777$p_1.2461@tornado.tampabay.rr.com...
    >> We are having trouble getting all of this to tie together properly...
    >> Maybe someone would be kind enough to grind through the below and give us
    >> some help.
    >>
    >> Given table structures like...
    >>
    >> - tblA relates to tblB relates to tblC - (A:B is a One:Many --C:B is a
    >> One:Many)
    >> - tblA relates to tblX - (A:X is a One:Many)
    >> - Now we have a field in tblB that we want to popuulate with the value

    > from
    >> a field in tblX.
    >> - We would like to use a Combo Box to do this.
    >> - The values the combox box presents must have its idA = to the idA in
    >> the
    >> tblX record.
    >>
    >> So we may have...
    >> tblA with fields idA, A1, A2, ect
    >> tblB with fields idB, idA, idC, B1, B2, etc
    >> tblC with fields idC, C1, C2, etc.
    >> tblX with fields idX, X1, X2, etc
    >>
    >> for tblA.idA = 1 we will have several records in tblB
    >> for tblA.idA = 1 we will have several records in tblX
    >> we want the combo box for populating X1 to choose from the values in B1
    >> where tblB.idA=tblX.idA
    >>
    >> And we are trying to do all of this on a single form with subforms.
    >> - tblA is populated on the form
    >> - related tblB records are created and populated on the form or subform
    >> - related tblX records are ceated and populated on the form or subform
    >>
    >> thanks for any help on all this.
    >>
    >>
    >>
    >>
    >>
    >>
    >>
    >>
    >>
    >>
    >>

    >
     

Share This Page