Andy,

>But VFP views have their own problems and any semi-complex views can be a bear to create for VFP.

If the view is more compley than the View designer can build, use Erik Moore's eView or just code them in a PRG using a CREATE VIEW command then you have complete control over the SQL.