I have a large FPD 2.6a App that has grown over the years.
Large number of Tables (over 100+).
(Multi-user, running under Novell 6.0 and 6.5)
Pretty much error free, BUT,....
It is out of index far too often.
I need to revisit the code and look for possible coding errors or concepts that could cause an Out of Index condition.

If anyone remembers all the Do's and Don'ts regarding tables. I would appreciate suggestions.

For Instance, I seem to recall reading somewhere to Set Order to 0 before an append/insert into, and possibly before a Delete next 1. (I don't do that now, and don't know if it matters).

Any thoughts or experience will be appreciated.