Hi Julie.

Are you using eView or ViewEditor to edit your views? If not, you really should. Sounds like the key field isn't set properly or the update fields aren't properly prefixed with the table name and database.

HTH

Dan

>It is just select * from A. No filters or joins nothing difficult... I even tried changing the order in the view definition to get select fielda, fieldb from A and still same thing. My tableupdate returns not successful, how can I find out why?
>
>Thanks again.