Thanks for reminding us, Erik. I thought of EView when I first read the message, and then forgot to include it.
Barbara
>Barbara, Willie-
>
>Please take a look at eView. Makes modifying these complex views a snap.
>
>
>>Welcome to the club. I got the same message with a nearly identical view yesterday. The VFP View Designer isn't designed to handle multiple joins. Write out your SQL in a small PRG and test it, then add the CREATE VIEW code to put the SQL into the DBC as a view. You will have to use the PRG to update the view if you wish to change it. Opening it in the view designer will give you the same error.
>>
>>HTH
>>Barbara
>>
>>>Hi to all
>>>
>>>I have the following situasion:
>>>A sales table with a buyer client no. (cnum) and a seller client no. (cnum2). I now want to create a view with
>>> 1. sales no. (from the sales table)
>>> 2. the buyer's name (sales.cnum -> client.cnum)
>>> 3. the sellers name (sales.cnum2 -> client_a.cnum)
>>>
>>>My view retruns the correct data. However, if I exist the view and open it again, I get the error, SQL: Column "CNUM2" not found.
>>>
>>>Anybody have an idea why I'm getting this?
>>>
>>>Thanks in advance
>>>
>>>Willie