Hi Scott,
>
>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.
>
What kind of corruption were you experiencing? Are you referring to the inaccurate Views/Queries as corruption? The View Designer is NOT a good tool for Views with more than 2 tables. (Check out Eric's EView for a much better tool. Or maintain them in code. I use a combination of both.)
>I join table1.mfg_code to table2.mfg_code and table1.eq_code to table3.eq_code. My results from the first 2 tables are correct but when I look at the column from table3 (desc), all the records are showing the same descriptive value.
>
This sounds like an inaccurate join condition. Could you post a subset of the 3 tables and the query in question?
>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 problem with the View Designer. As I stated earlier, don't use it with more than 2 tables.
HTH,
Bill Armbrecht
VFP MCP