Thanks Edward,

I've wondered about this for a long time myself.

David

>>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.