>>>>I am trying to set up a SORT FORM where my users can
>>>>SORT on anyfield.
>>>>
>>>>Any suggestions?
>>>
>>>How large are your tables?
>>
>>They are small, but in a multi user environment.
>
>It's important that you index every sortable field. Otherwise you'll have performance problems as your tables grow. At least I like to plan the future... (Hmmm, I did I chose programming?) :-)
If you index your tables and when you call on a SELECT statement, how
does the SELECT statement know your tables are indexed?
thanks..rob