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