>My real problem is updating ..... when I append blank to the view, replace data in the fields, then tableupdate(), It doesn't append blank to the underlying table -- it overwrites whatever record it's sitting on.
I suspect that there's a problem with your key for the update - if you duplicate a key, there's no need to create a new record. I suggest you examine how the view is defined.