>>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.
Correction, I AM using a LEFT JOIN. Lost track of where I'd learned what. Obviously I had to use a left join for a one-to-some relation.
Rich Addison, Micro Vane, Inc., Kalamazoo, MI
Relax, don't worry, have a homebrew.
- Charlie Papazian, The New Complete Joy of Home Brewing