>>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.
Is this another one of M$'s 'undocumented features' :-) Thanks for the info Ed.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.