>>I have a form that I want to use to display a parent/child relationship. The child table has 2 fields displayed in a grid. I have a container class with next/prev buttons. The "next" button contains "skip 1" and "Thisform.Refresh()". I have discovered that I am missing something. If the child table has more than 1 record for the corresponding parent record I have to press the "next" button once for each child record to get to the next parent record. It seems like the button is switching the alias to the parent table prior to issuing the skip 1 command. I know the button code is primitive and needs more code but what code would allow me to operate on the parent table records?
>
>In your buttons code you should explicitly select the parent table before doing any operations.
It turns out I had the data environment relation's OneToMany property set to true (similar to the SET SKIP command). I didn't understand this property's usage when I was just trying various things to get the form to work and that was one I set as I was blindly stumbling around. It goes to show you what trouble a relative newbie can get into if he/she starts changing properties willy nilly. I discovered this property even while Gerry Newton was writing his response to me that suggested this very solution.
Thanks for all of your patience.
Larry Huisingh
Lockheed Martin Information Technology
Richland WA USA