>I have a query which results in say 5 records which I update. In the meanwhile another user runs the same query and deletes 3 of these records and updates the base table.
>Subsequently when I issue a Forced Tableupdate on my 5 records (nothing deleted), I find that the 3 records deleted by the other user, remain deleted and a ReQuery results in 2 records only.
>
>How can I overcome this so that the last User who saves wins ALLWAYS.
If these are views, you can change the update properties to DELETE then INSERT, instead of UPDATE.
Erik Moore
Clientelligence