>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...