As Mark said, if you are using relations between tables you will break that relation if you change the index order. However, you can use several indexes with the same relation: If you want to link by Primary ID, you can have an index on Primary ID + Name, another on Primary ID + City, etc. Then changing the index tag will still keep the relation working.

HTH
Barbara

>I have a primary and secondary which are linked by using the dataenvironment. I do have a filter on the field I have linked. I would like to be able for the user to click on the header and sort any field. When I put set order to field1, thisform.refresh, the grid goes blank. I believe maybe when I change the order, it breaks the link, how would do I sort the field?
>
>TIA
>Jim