I have been making an attempt to use local views. I have noticed however that when I do that the process seems slower when sending updates back to the table than using the tables directly. I am using send SQL updates, key and modified fields and update using sql update. I have an index built on the key field. Is there anything else I need to be doing that would make the process faster. I am just selecting one record from the table and then sending any changes back.