>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