Combo box riddle

[Will]

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.

 

[Jeff Boyce]

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?

 

[Will]

Jeff,

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

thanks,