>Nadya,
>
>Make sure the view is updating you primary key field. If the primary key is not UPDATABLE in the view then you will get the results you are getting because VFP is not trying to write the primary key back to the table.
>
>Will
I never have the PK as an updatable field in my views if I have defined a function call to a SP as the default value for that field in my base table. When I issue the TableUpdate(), this SP fires when a new record is added. This always works because I use surrogate integer PKs that can never be changed by the user.
Mark McCasland
Midlothian, TX USA