Jim,

I have an index on each field separatly and one index with the 3 fields combined. If I use sys(3054) and do select it always returns "None".

I have tried to find as much info on the sys(3054) function as I can but
I can not figure out what I am doing wrong. I have an index on deleted() along with the ones mentioned above and when set deleted is "ON" is the only time that I get anything other than "None"

What am I missing?

Thanks for you help

Jeff Whitaker



>>35,000 records
>>set filter to fielda = a and fieldb = b and fieldc = c
>>indexes on major fields
>>
>>for the filter I have an index like this:
>>index on fielda+fieldb+fieldc tag tag1
>>
>>Thanks for your suggestions
>>
>Jeff,
>
>Your index is wrong for Rushmore. You need three indexes one each for fielda, fieldb, and fieldc.