>I am using VFP 5.0
>
>Updateable view is created using multiple tables. Buffer mode is set to 5.
>View's Updatation criteria saves data only in one table.
>
>It takes very long time to complete the save operation!
>
>TIA

If you don't need conflict detection, in the View designer set "SQL Where clause includes:" to "Key Fields Only". If using a SQL database, set to "Key and Timestamp" which allows for some conflict detection, but is much faster than "Key and Updatable Fields" or "Key and Modified Fields". The more columns you have in your tables, the more this setting becomes a performance factor.

However, if you use "Key and Updatable" or "Key and Modified" then under View-Advanced Options dialog, uncheck "Fetch Memo" and/or "Include Memo Fields in WHERE Clause" Taking memo fields out of the comparison can greatly speed things up.

- Bruce