If I understood You right You crate an order to a table in Table designer. So You must use SET ORDER TO instead of SET INDEX TO

** When to use SET INDEX
SELECT MyTable
INDEX ON Field1 TO MyIndex
SET INDEX TO MyIndex

** but when You create the order via Table designer or by the following command

SELECT MyTable
INDEX ON Field1 TAG MyTable

** You must use SET ORDER

SET ORDER TO MyTable