>My best advice - and my only practice - is to learn to love dbSetProp() and NEVER use the view designer for anything. It's pretty worthless in my mind.
Well, I basically agree about the designer, but there's a new & better way to do this: download Erik Moore's Eview program (that's what Sylvain was referring to, I believe) from the files section. You can begin your view in the designer, to select tables and fields, maybe. Then use Eview for the heavy duty work...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.