>>>
>>> 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.
You cannot sort records properly with the index like that.
--sb--