Willie,
Look in the Files section here on UT (yellow file cabinet). It's called 'eView', is by Erik and is in the Visual Foxpro in General section.

Barbara


>Hi
>Thanks Barbara and Erick for the reply. I thought I was doing something wrong that nobody replied:).
>
>Erick, where can I get info on eView.
>
>Thanks
>Willie
>
>
>>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