It looks like your suggestion works. Thank you very much!

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.

2.) Could anyone suggest any other articles, view utilities, etc. that might help me with VFP views? (I did find a utility "eview.app" by Erik Moore that is helpful.) Any other resources I should know about?

Thanks again!