>Yes, I guess that does help me to here that someone has confidence in using more then two tables at a time in a view. Many have steared me away from that practice.

Also, Dennis, for a report, which is read-only, why use a VIEW which needs to write to the DBC. Use a cursor instead, using SELECT ..... to cursor .... instead of Create SQL View.....

Barbara