Hi, Terry
They are Dbc tables, but the grandparent table is loaded by me in the init of the form.
>Beth
>
>Are they dbc tables, featured in the DE, or made-to-measure cursors?
>
>
>>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