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.