Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with grid displaying information from related ta
Message
From
08/02/1999 17:00:46
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00185263
Message ID:
00185291
Views:
19
>I have a form that contains a pageframe with three pages. The first page contains the information for the parent record and on page three, I have a grid that displays a view of a related child table. In this grid I show a description of the record which comes from a different table that my view has been given a relationship to. I also use navigation buttons at the bottom of the form. When situated on the third page and use the "Next" and "Previous" buttons and issue a requery and a refresh from the related methods, everything works great and the descriptions of the record types display correctly, but when I am on the first page and do some manuvering and then go to the third page I see the correct records but not the correct description until I use the "Next" and then hit the "Previous" buttons.
>
>Additional information: On the activate of the third page I am also doing a requery if the parent has changed.
>
>Any help or suggestions would be much appreciated.
>
>Thanks!
>
>Dave Martin :-)

Hi Dave,
When a page activates Foxpro will automatically select the right table to refresh the grid. If you fool around with other tables in the activate event then things can run crazy. Try setting the selected table back to the parent of the grid prior to the end of the activate, or similar such stuff
HTH
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform