>I do it all the time. One thing to watch out for: Always make sure that the view you need for the second view is open.


There is one other thing to watch out for. Both the first and second view are updatable, yes? If you update the first view, have not yet done and explicit or implicit tableupdate() to write to changes to the base tables and then query the second view, the results will be based on the original query results BEFORE you made changes, not on the changed result set.

This may not be a problem for you. (Perhaps you are executing both queries before changing any records.) Just a point that is easy to overlook...