>So if the field and index name of the primary index is- itemcode -then the index should be- itemcode + not deleted()?
You can add the ".NOT. DELETED()" to the index by modifying the table structure. If you can also create the index by using the INDEX command:
INDEX ON itemcode TAG itemcode FOR .NOT. DELETED()
I'm pretty sure that'll work. If not, experiment...
Ronald Suen
Epic Information Solutions Inc.
Ph: (780) 488-4418
Fax: (780) 488-0402