>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.
VFP View Designer cannot handle complicated views. The workaround is to create/handle view programmatically.
Edward Pikman
Independent Consultant