Jill,
There was a problem answering your thread directly, probably because of the ">" in your title. So......
I've inherited a project that does this multiple times per form. Views of views of views with at LEAST 2 DBs, sometimes 3. So far there isn't any trouble except keeping it straight when coding. Users don't seem to have problems with the final compiled code at all.
However, I personally wouldn't do it this way if starting the project from scratch - if only because the cost of upkeep is so high. Every time a new programmer joins the team it takes weeks to learn how the data works.
MHO
Barbara