Creating an index using code? Any other way besides on the table?

[Matrix_zero]

I am pullling data from a query using an unbound form and a query that that uses linked tables. I can not edit the index of the tables, so is there a way i can create a new index for sorting data in a form?

 

[Uncle Gizmo]

You can use DAO to create a new table and append data to it and also create indexes.

Or:
Roger Carston has an example on his website where you can number the rows in a query. This might be an option...

 

[Pat Hartman]

so is there a way i can create a new index for sorting data in a form

If you want the records in a form to be ordered in a particular sequence, create a query with an order by clause and use that query as the form's RecordSource.