I constantly run into a problem when adding fields to an existing table. Create a local view based on a table in the DBC. Make all of the fields in the view updatable, including the primary key.

Then go back and add a field to the original table. The view is no longer usable, unless you modify it, and then the system tells you that the table and the view do not match, and resets the update flag on all of the fields back to not update. If you have even one field in the view that is not marked to update, then this does not happen. What should I be doing differently?

Thanks
Bill