I created a view based on 4 tables: Crseinfo (Course Information), Crsedtl (People enrolled in course), People (Person Info), and Trainer (Trainer/Teacher Info).

There are JOIN's between Crseinfo and Crsedtl on a modulecode and levelcode, Crsedtl and People on a personcode and Crsedtl and Trainer on a trainercode.

The view runs great and saved fine but now when I try and modify it I get the error:
SQL: Column 'TRAINERCODE' is not found.

Trainercode is not a selected field for the view and is only specified in the JOIN. The only info in the view from the Trainer table is a concatenated field of fname+" "+lname. Why is this happening?

Also, even though I can't edit it the view still runs fine.