>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-
the view designer becomes dysfunctional when used on views that contain more than one join. You'll have to find another way to maintain your views. Check out eView from the files section here- it lets you open any complex view, and does some other cool stuff too.