>I just add a situation where I was not able to open my view, in the form loading time, because a table necessary for that view was not found.
>
>I just realized that the necessary tables for that view need to be before the view in the order sequence of those tables in the DE. I had to remove the view and add it again at the end.
>
>Is there a better way to handle that?

I usually put that in the .BeforeOpenTables of the DE. I have views too complex for the view designer so the CREATE SQL VIEW command is embedded in class definitions. The classes are added in .BeforeOpenTables and there are methods that do the view creation and there is a method to add the view definition to the form's DE. I've also found that I don't need the base tables from which the views draw data from. But I've also found that these base tables are not closed when the form destroys. I may have to include them in the DE.

Steve Despres