I am using vb 6.0 to create a database utility accessing an Access DB. I created an data environment, added tableX as a command and then added tableY as another command. I related the two tables by way of recordset"IDNUM". tableX is a list of people assigned an Id Number. tableY is a list of people assigned an ID Num that corresponds with a person from tableX. So a person with the ID # 1 (from tableX) may have 20 people assinged to them by the ID #1 in tableY. My question is, how do I also access tableY in the same manner as I would with tableX. For example, I have three text boxes bounded to each table. When I .movenext through tableX it displays "IDNUM", "First Name" "Last Name" and also then displays the same info from the corresponding "IDNUM" of the first person in that list)from tableY). Now lets say I want to .movenext in tableY so that I see the next person in the record that corresponds with the ID NUM from tableX... datDataEnviro.rstblTableX.MoveNext, moves tableX, datDataEnviro.rsTableX.rsTableY.MoveNext returns an error of "Method or Data Member not found" does anyone have any suggestions? Does my babble even make sense? Any help would be appreciated! Thanks.

Yardgnome