General information
Category:
Forms & Form designer
Title:
Linking fields to second table
This may be a dumb problem, but for the life of me, I can't see the solution... (I'm still a beginner at this, so please excuse.)
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?
Thanks,
Neil Preston
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only