I was forced to do some development in Access over the last half-year and used quite a few views in the process. I'm now starting to work more with views in VFP and have come to the following conclusion.
I really like the fact that in Access I can toggle back and forth between the SQL window and the designer window when modifying a view. Changes in one window are faithfully replicated in the other. In VFP the SQL version is readonly.
For the record, so no one can say I'm blindly attached to FoxPro. (Attached yes, blindly no. :)
Peter Robinson
Peter Robinson ** Rodes Design ** Virginia