>Here is a question bother me for a long time,as follow
>I got a master-detail form,the master part uses table order1,
>the other use order2 and goods in grid under relations.
>when I edit the grid that contains 2 tables,I got a 'record is locked by
>other user' message,but I am not under any network,Is this VFS`s BUG?
I'd say yes to that. I don't know if it's been fixed in 5.0 (my code all works around it), but 3.0 will lock part of the index file when a record is modified, and give you trouble with it until you move the record pointer.
The easiest way to do this is to put a "GOTO RECNO()" after you insert a record. As long as you use table buffering, not record buffering, this won't do anything except free up that locked index.