Hi Ken,

>I have a form with two grids. Grid1 displays the typical parent/child 1 to many info. Grid2 two uses the same tables but the child is now the parent with a 1 to 1 relationship.

Where are the grids? I would do it like this (not knowing anyhting else about your data):

Make a PageFrame, make the first page a grid with the parent table. In the filter property of the Child cursor in the data environment, put: "Child.ID = Parent.ID", then setup a relationship from the Child to your GrandChild. And put the Child in a grid on the second page, plus the needed columns of the grandchild.

Does this make sense?