>>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
>
>i think a view builder error. i ran into that a few times and gave up on using the builder...

This has been covered several times here recently. It boils down to a bug with the view designer. If you cut and paste that same SQL into the command window, it runs fine. Your efforts are not wasted, however, you can still cut and paste the SQL into your code and define your view there.