Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Linking fields to second table
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Linking fields to second table
Miscellaneous
Thread ID:
00233115
Message ID:
00233115
Views:
45
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
Map
View

Click here to load this message in the networking platform