>I'm having a wierd error come up. When I check the errorlog, it says it can't find the variable "tname". Tname is an index. I did a modify structure on the table, and confirmed that the index is still there. This was working just fine before. Do you know any reason it would suddenly stop recognizing the index? What can I do to prevent this?
Maybe tname is a variable which was available when index was built, and now it's not, and also there's no field named tname in the table. I've seen this many times. Fox won't warn you if index expression contains something unrelated to the table, but next time it tries to open the table, it finds it can't resolve the index expression.