>VFP 7
>I need to add a field to at table. A form uses a view to retieve data from the table (which will be dependend on value of the new field). When I add the field to the table I get the error message 2005 with the message
>

>Error loading file - record number 14.  frmIntDepII <or one of its members>.Loading form
>or the data environment : Base table fields have been changed and no longer match view
>fields. View field properties cannot be set
>

>What does this mean and how to I fix it?
>
>TIA for any help.

Since underlying table changed (you added a field), you need to recreate the view. You will need to remove and re-add the updated view to the dataenvironment.

Note, if your view looks like SELECT * from ... then you will get an error when changing the underlying table structure. But if the view is created like
SELECT field1, field2, field3... you will not get an error. You will just need to add the new field to the view if necessary.

Similar thing may happen to a grid that refers to the table/view where you changed the fields. Make sure that the field in the table and in grid column controlsources match.