>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
Hi,
The view designer is very tricky. If you did a complex view (More than 2 tables). You will have some problems. Either you chos to use filter as join or you do your CREATE VIEW manually.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only