>I also tried to use the index for the CLIENT number and a SEEK() but when I tried to add a SET INDEX TO CLIENTNUM I got an error about table/cursor buffering which through me. (I still need to work on the buffering stuff for this app... right now everything is set for the defaults)
PMFJI, but a commment here: you need to set buffering off if indexing at runtime, then back on again after you index, that's the error you're gettting.
>Is there a way to have more than one INDEX available at a time on a form? Would I add multiple instances of the file in the DE and set the ORDER property differently or something similar?
Yes, it's better to make the indexes at design time. In addition to what Mike said, it's easier to use SEEK():
IF !SEEK(value,'table','tag')
* for example
then you don't need to set and reset the order.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.