Are you using any table aliases in your index expressions? And if so, are you openeing the table with a different alias?

>there is not filter. I do use "select &tmp" to select the table. I tried to open the table alone and it opens up without a problem.
>sherry