>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?

Hi Larry,

Everybody else's comment that you need to select the parent child in the next button is valid. If you have a relation set in the Data Environment make sure that you don't have 'OneToMany' set to True for the relation between the two tables. This will cause the record pointer to skip through the related child tables even if the parent table is selected.