Randall,

>I think I may have phrased this wrong. The indexes have already been created. They simply click on a search icon and choose an index and put in the data. The search then indexes the table to what they choose and presents the outcome. This is why I am wondering if I should use the table AGAIN to give the user their own incident of the table.

If the Indexes already exist, then you just need to:

USE mytable
SET ORDER TO someindextag


Each user will be in the same table, but they will each be looking at it in a different order. This assumes SET EXCLUSIVE is OFF, or else you need the SHARED clause. The AGAIN clause is not needed, since it is intended to allow the same user to open the table more than once, but with different aliases.

If the indexes did not exist already, you could do a SQL SELECT with an ORDER BY clause that is determined by the user's selection of the order desired, to give each user their own cursor or temporary table for viewing purposes.