>I am using vfp 5.0a to create a local view file. The view file included 7 tables. One of the tables was master table with one primary key. The others have candiate keys. While I finished the creation and close the view designer, a error " SQL:Column "FIELDNAME1" not found" shown on the screen. I checked the tables. I didn't find anything wrong. Each table had the FIELDNAME1. The FIELDNAME1 was indexed already. Any idea?
>
>Sunny

This is a documented bug that is addressed in the Microsoft Knowledge Base. You can do a search on SQL VIEW to retrive the article.