I recently had a broken link in my SO file in my sales volume. I manualy removed all the indexing as done in TB#56. After removing all the old indexing and the bang file I was able to rebuild all the indexes (5 btree and 1 cross)without any problems. When I tried to rebuild the relational field, exactly the way it was built prior to the link break, I got an error that the file VOIDED.SO already had a relaional index established with my key field SO.NUM. When I went to look at this file it had no indexing on it at all. As a matter of fact it didn't even have a 0 key field.

I thought possibly that the VOIDED.SO file still had some indexing information still left on it so I went through the manual removal of indexing on it also, to no avail. Everything seemed clean.

HELP!!!

Thanks,

Wayne Tafuro

MIS Kitchens of the Oceans

[email protected]

Have you tried following what's outlined in the Rebuilding Relational Indexes Using R/BASIC Knowledgebase Article?

[email protected]

Sprezzatura, Inc.

Aaron,

Thanks for the reply and yes I did look into the R/BASIC fix. I was able to resolve the issue before having to build code.

Wayne

View this thread on the forum...