>I really need to update the other fields besides the key ones - these ones are even not updated.
OK, so you select which fields you want to update.
What I meant is under "SQL WHERE clause includes" - here, you select "key fields only". This should make the view faster, in some cases, IMO. This option does not mean that only key fields will be updates; it means that only key fields will be used to search for the record.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)