%RECORD% in data portion of table#

We've had an ongoing issue with a select against the PAYRUN table returing fewer records that is the case

Still don't quite understand how/why/where the index was created, however using the b/s OI table builder added no value

So to check and remove the index, do it manually

RUN ATTACH_TABLE "d:\databases\{CUSTOMER}\mmsoi\MMSDATA","REVMEDIA"

edit the "REVMEDIA","PAYRUN" record shows this:

 REV26431
 RIGHTDEX.MFS
 MMS

the fix#

remove the entry and save the record away removes the index