Thank you, Josh, I also thought about requery(), but I feel it is a little bit too expensive. Anyway, I am in a hurry and I will just requery() for the time being.


>If you REQUERY() the view each time the user saves a record you'll avoid the update conflict.
>
>>I have a remote view. A user edits a record in a form and click the save button, so far so good and the record is updated in the SQL Server. The user keeps making changes with the same record and click the save button, now I get update conflict. How do i avoid this conflict? My code dose check for update conflict when a different user update the same record. TIA
>>
>>Chen