>Fantastic, thankyou borislav
>
>Does this mean I dont have to set the index upon searching, I basically just have to create one. The reason I ask this is there could be some more fields I need to add for searching and I was wondering on whether I just have to create them or set the order to prior to searching?
>
>Thanks
If you just use SELECT - SQL there is no need to set order, recommendation for Rushmore Optimization is the table not to have order. But if you want just want to SEEK you need to point the order, no metter how, If you don't the current order is used.
:o)
I don't know if you uderstand something from this explanation, I hardly understand myself :o)))
Check
Using Rushmore Query Optimization to Speed Data Access in HELP for more valuable info.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.