When you create a view in the View Designer, and select all fields in the view, VFP constructs a select statement like this:
SELECT * FROM table ...
Then it stores additional information about all of your fields. Now, if you add a field to the table, the view 'breaks'.
To get around this problem, after selecting all the fields, change the order of two of the filelds in the selected field list. Now the view designer constructs the select statement listing each field:
SELECT field1, field2, ... FROM table ...
Now when you add a new field to the table, the view doesn't 'break' and your settings will be preserved when you go back to add the new field to the view.
>WHY do the update criteria on my views COMPLETELY reset whenever I change/add fields to my tables? It's such a pain, because I don't remember how I want the update criteria to be set!!! Isn't there a way for it to remember the criteria, but remind me that I now have a new field added to that view that needs to be set?