I've created a local view base on 3 tables using default relations popped up by VFP when I added each table, selected fields I wanted to include, checked SQL Update option, and saved the view.

Now, when I try to edit the view, I get an error "SQL: Column 'CAMPCODE' is not found". I know that field exists in the table and is a pkey of one of the tables I'm using. I could delete the view, recreate it the same way and when I try to edit, same problem. I could use the view but not edit it! Any know how to fix this?

TIA
John.