>I'm using an integer primary key and wonder how I can get the child data in a grid to be sorted in an order other than the foreign key used to relate to the parent.
>many thanks
>Jeff

You can use parameterized view as Grid.RecordSource. This view can be indexed on fly, and therefore you can sort grid records resetting SET ORDER.