One of the limitations of the view designer is that it has a tendency to flip out if you've got more than two tables in it. About the only way around this is to avoid using the view designer and just modify the view programaticly. As far as the problem with your current view, your SQL statement has some stuff in the wrong order somewhere.
>I've created a local view base on 3 tables using default relations popped up by VFP when I added each table, selected fields I wanted to include, checked SQL Update option, and saved the view.
>
>Now, when I try to edit the view, I get an error "SQL: Column 'CAMPCODE' is not found". I know that field exists in the table and is a pkey of one of the tables I'm using. I could delete the view, recreate it the same way and when I try to edit, same problem. I could use the view but not edit it! Any know how to fix this?
>
>TIA
>John.
ICQ 10556 (ya), 254117