>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.