> Yes, I am using table buffering - 5. I did issue TABLEUPDATE() in 1st instance and it return .t. too. The data in seach form (1st instance) give me the most updated data. But, the 2nd instance doesn't. Any mistake here?
> Lock record? Do you meant I need to LOCK and UNLOCK the table when i am updating reocrd in 1st instance?
Hello, John.
I think I didn't understood your problem before.
If the situation is that you reach the same record in both instances, edit it in the first one, update changes, and then, when you switch to the 2nd the data doesn't reflect the change, all you need is to refresh it.
Try putting THISFORM.REFRESH() in the form's activate. You'll see the data changing as soon as the form gots focus (not sooner). If you want the form to reflect the change even without getting the focus, you have to scan trough the forms collection of _SCREEN and refresh them all (or maybe the ones that have the same name or caption that yours), after you issue TableUpdate().
Please tell me if I wasn't clear.
Good luck.