Use p-views for your information. If it would not be VFP6, I would suggest CursorAdapters with the same idea...
>Hi all
>
>I have a form with several different grids on it, each on their own page. Each grid has a different recordsource, but the cursors are all related. There is the parent table – Customers, and serveral child tables – Addresses and Contacts. Everything works okay until the user wants to work with a smaller data set. I add a Grandparent Table – FilterCustomer which limits the Customer table. When I do this, the two child tables refuse to work correctly. I have put code into the click and activate method of the pages trying to get this to work. The code was:
>
>local lcAlias, lcCust
>lcAlias = ALIAS()
>lcCust = Customer.custmer_id
>SELECT 'Customer'
>LOCATE FOR custmer_id = lcCust
>SELECT 'addresses'
>LOCATE FOR custmer_id = lcCust
>SELECT (lcAlias)
>
>This will get the text boxes on those pages to show the correct info, but the grids are not correct. And as soon as I click on a cell in the grids, the textboxes are incorrect.
>
>Can someone help me here?
>
>I am using the basic VFP Forms and buttonset.
>
>Thanks,
>Beth
If it's not broken, fix it until it is.
My Blog