>I noticed that the update criteria in the view designer defaults to "Key field and modified fields".
>
>I suspect "Key fields only" would be more efficient, because the WHERE clause thus generated would only involve the PK. I use a single field for PK; the same field would appear in the view.
>
>Any comments?

Hilmar,

I have been taught to use Key fields only. I think I started that way when it resolved a memo field issue. Makes sense that it should be the default instead of the way it is now.

Renoir