>Rich,
>When you populate the view, you make LEFT JOIN (i guess)
P.S. - no, bad programmer again, I used an old-fashioned WHERE clause for the view's join condition. Started this app before I'd really boned up on JOIN syntax.
Rich Addison, Micro Vane, Inc., Kalamazoo, MI
Relax, don't worry, have a homebrew.
- Charlie Papazian, The New Complete Joy of Home Brewing