>I created the index in a view table from MS sql table
>thank I set the order
>howerver when I quit fox and come back try to run it again
>I get table has not index order
>why
>any help
>thank you

Views are temporary files. You need to create index again.
Cetin