>>

>>  alltrim(reportedby)+alltrim(takenby)+alltrim(testedby)+alltrim(progname)+ ;
>>    alltrim(catg_1)+ alltrim(catg_2)+ alltrim(catg_3)+ alltrim(catg_4)+alltrim(str(priority))
>>

>Hi Beth,
>
>Are you sure you need this index at all? I would remove it and see what blows up, if any.

Yes, the index is needed to sort the records in a grid. We still open the table directly and work with it. I can not convice them we need to go to CA or views. Opening and working with tables is so-o quick, compared to views and SPT that we see.