What type of buffering are you using?
Are you using optimistic or pessimistic locking?
What method is employed for adding the new record?
How is the last price computed? What values is it based on?
If you post your code, others may be better able to assist you.


>Hi
>
>I am using VFP8 with a form one-to-many in a multi-user environment. I have the main software on each pc. And the data on the server.
>
>When two users are using the same form "invoice" and entering two different invoices, the last price will be saved on both invoices. although other information are kept like item no, date are not changed
>
>Please advice and help, thank you in advance.
>
>
>best regards
>ahmad zrein