I've had a parent child grid working for many months, just fine.
The parent table is "WPage" the child table, and the recordsource of the grid, is "Product".
I've got as Grd1 data properties...
Childorder WPageId
LinkMaster WPage
RecordSource Product
RecordSourceType 1-Alias
RelationalExpr Wpage.wpageid
Now all of a sudden the grid doesn't show the records belonging to the parent. (except intially) It's stuck!
If I put a command button on the form with "this.parent.grd1.refresh()" as the click event it comes good when clicked. And it refreshes with every "Next" "Prior" etc after that. If I put the same command in the refresh of the page, or in the activate event of the page it fires but doesn't work. That's weird! The data environment hasn't been changed at all from when it was working.
I've had this sort of problem before and I just don't get it! My experience says that if I rebuild the whole form it will probably work. But in this case it's going to take days to re-do.
I know I should use views, but I don't want to re-write the whole shebang at this point.
HFH (hoping for help)
Next
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