Thank you. It may be another good solution.

Sunny

>>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 Yung Hung
>I encountered that problem at the beginning of my experience with VFP5 and as I red in the replies to your message, I'm sure it's a bug.
>What Erik told you is right but I think to remember that sometimes (random I suppose) the same error appears also using the code generated by the wizard.
>Now , in my sql statement I'm using the VFP 3 syntax : No Inner Join but a simple 'where ' statements and it seems to work fine
>
>Ciao Alessio