>>Could you tell me what's happening here.
>>
>>I made a view (made it with VFP view designer and Stonefield Database Toolkit) and the same problem occurs with either.
>>
>>At one point I receive the error "SQL: Column 'Alias.NameOfTheField' is not found.
>>
>>I corrected that problem by changing the order of the join in the join tab.
>>
>>What would be the explanation to this?
>>
>>How to be sure it won't happen again?
>
>Denis, how many joins did you have?
>View Designer just doesn't work properly with 2 parallel joins into 2 tables from another one.
>But you can create such a view programmatically.
Two joins. It looks like this. Table1 Joins Table2 Joins Table3
*******************************************************
Save a tree, eat a beaver.
Denis Chassé