Renoir,
As long as the fieldnames are unique, you won't run into problems. If you SELECT * FROM more than one table and there are duplicate fieldnames, then VFP and SQL Server automatically change the fieldnames in the resulting cursor. However, if you use a fieldname without tablename that exists in more than one table, you'll get an error (both in VFP and SQL Server).
>The View Designer adds the alias to all fields. ViewEdit (third-party product and an excellent one too!) does not require this. Just for the sake of arguement, will omitting the alias in the fields list cause any problems? These are local views, but I would like to know also if there could be issues if the data is moved to SQL Server. Thanks!
>
>Regards, Renoir
Daniel