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