>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

You might try looking at the .ChildOrder, .LinkMaster and .RelationalExpr properties of your child grid and using them.

Steve