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

Click here to load this message in the networking platform