>The view designer has hiccups with complex view. Try the eView utility in the files section.
>
>>I'm attempting to create a view in a VFP 5.0a project, all tables forming the view (4) are in the dbc in the project. I use the View Designer instead of the wizard. Everything comes up roses when I run the SQL from the View Designer, giving exactly the results I expected. The problem occurs when I attempt to save my view.... I got an 1806 error. I then deleted all views in the project(and in the project directories) and started over. I rebuilt the project, and then built my first view again. Roses, until I attempt to save the view, then I get... SQL: Column 'IDENT' is not found. I look, I see the column, It's a primary index in one table (Mail), and a regular index in another (new_class) and a field in both. The SQL generated by the View Designer is:
>>
>>SELECT DISTINCT New_class.*, Instructor.instid, Instructor.lname,;
>> Instructor.fname, Classcod.title;
>> FROM outdoor_woman!new_class INNER JOIN outdoor_woman!instructor;
>> INNER JOIN outdoor_woman!classcod;
>> INNER JOIN outdoor_woman!mail ;
>> ON Mail.ident = New_class.ident ;
>> ON New_class.class = Classcod.class ;
>> ON New_class.instid = Instructor.instid;
>> ORDER BY Instructor.lname, Instructor.fname

OK, I'll give it a shot...is it a designer too?
Ken