>
> >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 ?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only