>Updateable view

Then I think VFP is doing what it thinks you want. You may need to commit the changes so that the updatedView is current or (perhaps better) select from the real table.