Hi

This is problem with VFP that it never work like Oracle transaction session

Once u start the transaction and u make changes in a record it become locked
and u try to travers that table from another session it never work untill that lock released.

I developed a application and same happen with me, so i re-code it. Its my experience.