> > >Here is the situation : > > > >I have a form consist of 1 Pageframe with 5 pages. > >Page 1 for Parent Table entry > >Page 2 for Parent Table Record list using Grid (named Grid_A) > >Page 3 for Child Table Entry > >Page 4 for Child Table Record list using Grid (named Grid_B) > >Page 5 for Parent-Child show, with Child table shown on a Grid > > (named Grid_C) > > > >The parent table and child table were not related permanently in the > >database container. I only set the parent-child relationship when > >Activating Page 5 of the pageframe, and release the relationship when > >Deactivating Page 5. I set the record source for Grid_B in the Activate > >Event of Page 4 and the record source for Grid_C in the Activate Event > >of Page 5. > > > >But it seems that Grid_B on page 4 always reflecting the records show in > >Grid_C on Page 5. This is only happened after the first time I try to > >switch from Page 5 to Page 4. Especially when there is no related child > >records for the current Parent Record, the Child table record position > >is EOF. I already try to close the Child table and Re-open it before > >setting the record source for Grid_B but that's not work. Even I try to > >force the record pointer to move to the first (using "goto top"), it > >always back to the EOF position. > > > >I really appreciate any help, comments or advice to deal with this > >problem. I'm using VFP 3.0 on Windows 95. > > > >Thanks In Advance > >Tony > > Tony: Grid_B should show ALL the records if you haven't set any links to a > master table. Be sure that the LinkMaster property, the ChildOrder and the > RelationalExpr properties are all blank. > > If the relations persist, you might find it easier to use 2 copies of the > Child table. Set one with no filter, no relations in Grid_B and the other > with the appropriate links to the Parent table for Grid_C. > > HTH > Barbara Hi Barbara ! Thanks to your respond. You're right, Grid_B SHOULD show ALL RECORDS, but unfortunately it doesn't. All of that property (LinkMaster, ChildOrder and RelationalExpr) are absolutely BLANK and It's NOT a persistance relationship. By the way, the RecordSource Type is 1-Alias. However I have ever tried your second sugestion but I would have to add some extra codes to make it works. Because I want the selected record on Grid_B (Page 4) will be the record shown on Page 3 (for Child Table Entry/Edit). So if I used two copies of the Child Table then I have to maitained that the record pointer of Child Table (copy 1) is the same the record pointer of Child Table (Copy 2) when switching between Page 3 and Page 4. Thank's again Tony P.S. What is HTH stands for ?