>>Hi,
>>
>>I have same form running on ~5 PC on network on wich user enter new records. The code is general like: table buffered optimistic, use append blank to make a new record in both parent and child, make user data imput, make tableupdate inside transaction.
>>The PROBLEM is sometimes it's happening to 2 user save at aprox same time and get records saved one over another instead appended.
>>This is happening over 10 times a day and it's not posible working on an environement like this where user must check data after saving to see if gets errors; in my situation VFP is not usable for data imput. I verify code, network, add some reccount() as sugested on previous threads, check, recheck but the error does not disapear.
>>
>>How do you make data imput and saving; it's a known bug the 2 appended record goes overlaped?; workarounds?
>>
>>Thanks in advance!!
>
>
>Have you tried using "INSERT INTO" instead of append blank? I think this would solve your problem.

And should insert a blank record wich are further modified by user and then saved with tableupdate() ?
but this prevent the default values for fields get executed.