No, not in this form. The tables are part of a larger FPW2.6 application, but I don't think that should affect this.

Page one has several text boxes used for entering search parameters. A Search button gathers the search values and constructs the parameters for a locate command. (Several fields are not indexed, and don't need to be for the main application.) When the search is complete, it switches to page 2 and displays the results. On page two, I included some fields from the second table, which won't display the related data.

Thanks for the attempt...

Neil


>Is there a grid relating the two tables also? I have found that this can conflict with relations in the dataenvironment. The solution is to delete either the grid relation or the relation in the DE
>
>>Using VFP6 SP3 with database tables in FPW26 format.
>>
>>I have a standalone form with two tables in the data environment. The parent table is HS.DBF and the child table is HCONTACT.DBF. I have a relation set between the field 'CEEB' in the parent table to the index on CEEB in the child table.
>>
>>On page 2 of a pageframe I have text boxes having control sources in both tables. I am selecting the data either from a LOCATE routine or by a couple of navigation buttons on the page, each having a THIS.PARENT.REFRESH in the click code.
>>
>>The problem: Changing the record in the parent table will NOT change the fields from the child table. I've tried many things to solve it, including reversing the relationship, setting one-to-many to .T., and others. I'm out of ideas. What am I doing wrong?