Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One to many relation oddity.
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
One to many relation oddity.
Miscellaneous
Thread ID:
00562159
Message ID:
00562159
Views:
74
Let's say we have 2 tables, TRANS and MAST.
Add the tables to a DE in a form, and drag/drop the key field to create a relation.
Do not set the OneToMany prop of the relation to .T.

First scenario:
Add a grid for the TRANS table to the form.
Add a text box bound to any field in the MAST to the form.
Run the form.
What I consider odd is that as you arrow up and down through the grid, the textbox will not show the correct value in the Master. The record pointer in the master does not move according to the relation.

Second scenario:
Now, add a grid of the MAST to the form - do not change anything.
Run the form, and move trough the TRANS grid.
The text box will show the right value, and the MAST grid will refresh, the record pointer is now moving.

Epilogue:
Setting the OneToMany prop of the relation to .T., will fix the problem in the first scenario too.
All this makes some sense, but not quite... Can anybody explain what prevents the record pointer to move in the first scenario?

TIA
Doru
Next
Reply
Map
View

Click here to load this message in the networking platform