Joe-

>For testing (vfp7) I have a table (table buffered) with one char field and one integer field. The integer has a regular index. I create a view of this table, (the view is table buffered) and insert a record into the view.
>The view is updatable. I tableupdate the view after the insert. I then
>edit the same record (without a requery) (I change the char value) in the view and tableupdate again. The newly inserted view record is now marked as deleted. If I take the base table and remove the index from the integer field and repeat this process the record does not get marked deleted. What is going on?

This is the same issue we were talking about last week, right? Since it's related to a primary key, and since updates are done based on primary key, I imagine that updating the view, but not updating the table (since both are buffered, right) is causing the confusion.

I still think you need to resolve the issue of the table not updated before going on with inserting into the view.