>1.) This brings up a question. Did I do something incorrectly in the View
>Designer (VFP 6, SP3) or is the View Designer inadequate for what I asked it
>to do with multiple tables and left joins? My supervisor asked me about this
>and I'd like to give him a proper answer. Thank you.

Do these help?

http://support.microsoft.com/support/kb/articles/q156/6/67.asp
http://support.microsoft.com/support/kb/articles/q157/2/54.asp