>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...