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

(Sorry for the long response time; I've been swamped)

But tname isn't a variable. It's the name of the index. When you do a modify structure on the database, and click on the index tab, tname is there.

Thanks