Hello, John.

I suppose that you're using buffering (probable 5). Did you issue the TableUpdate in the 1st instance? Also, the best way to ensure the most current data is to lock the record (you can lock and release the lock immediately, this is just to force VFP to get the most current version).


>1. I have a customer data entry form which allow user to key in / update /seach /delete customer info.
>2. I will launch s search form which list out all of the customers in grid.
>3. After user select record in search form, the selected record will be LOCATE again in customer form and display it.
>
>It work fine in single user mode. However, I have a problem in multiuser environement.
>
>I have a simple test:
>1. I have 2 instances of my EXE.
>2. I repeat the steps 1-3 mentioned above for both of the instances.
>3. Then, I update the selected record in 1st instance.
>4. I go back to 2nd instance and launch search form again. The data in this form is not updated (which updated in 1st instance), even I release the form after I select the record and issue USE IN mytable in FORM.UNLOAD.