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.

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.

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).

I ended up creating 3 views of 2 tables each to ulitmately get to my desired result. Why is this happening? I never had this problem in VFP 3.0. I am using VFP 6 for this project.

Thanks in advance.

Scott