>Greetings,
>
>I recently removed all of my tables from my database because of occasional DBC corruption. When I try to create new views or queries of more than 2 tables my results are not correct.
>
Not sure what is happening here. You think the dbc was causing corruption in your tables? This would be the first I had heard of that.
>Also, when I try to save a view or query of 3 or more tables, I get an error saying a field name doesn't exist. When the tables were in the database, I would get this same error on 4 or more tables (views only).
This is a bug in the VFP view designer. Download my alternative to the view designer, eView, it will let you maintain more complex views than the view designer allows.
Erik Moore
Clientelligence