I have a grandpart, parent, child, grandchild (yeah, that's deep, but it's real) relationship in place with tables that I set up by calling a prodcude in a command file (I call it from the form Load() event)

The Grandparent fields are hosted in textboxes on the form outside of the pageframe (displays current record)
The Parent records are in a grid on page 1 of a pageframe. (1-to-many with above)
(the Child records are not display anywhere, but the relationship is required to I can chain to the the grandchildred.) (1-to-1 with above, on a per row basis)
And finally, the grandchildren are in a grid on page 2. (1-to-many with above)

I only want the relation Grandchildren (if any) to show in the page2.grid.

It all works if I open the tables and open browse windows in the IDE. (Meaning, each parent filters out the correct children).

However, in the form, when I pick a row in the page1.grid, and the go to page2, the grid on page 2 shows ALL records, not just the one that are children of the current parent on page1.grid. It does move the pointer to the correct child, but I get all these extra records.

If there are no children, it goes to the bottom, but I still see the last 5 or so records in the grid, even though they are not releated.

I've tried sing the Parent/Child properties on the grid, but I could not make that work. I've tried doing =seek() commands, but that does not help.

What to do?