Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Refresh
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00897786
Message ID:
00897828
Views:
15
>I have 2 tables related by code on a form data environment. It works just fine. I have the parent table code stored in the form textbox and the corresponding information on the child table store to a combobox which has all the child´s records stored. Whenever I move the parent table the child move to the correspondent record. But when I choose a record from the child table and cancel the action on the form, the information from the parent table are all restore to the original data from the table, but the combobox remains with the selection I made. Is there any way to reallign the tables without moving the parent or seeking into the child. Something like:
>dataenvironment.cusror1.relation1.refresh
>I hope i made myself clear.

I'd say that what you need to do is save the current record number, issue a REQUERY(), the going to the original record number you've saved. In addition, if you issue a THISFORM.LockScreen = .T. before the requery, then set it to .T. after you've moved the record pointer, you'll get the results you're looking for.
George

Ubi caritas et amor, deus ibi est
Previous
Reply
Map
View

Click here to load this message in the networking platform