>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.
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison