>I have parent and child table which are in relation.
>
>I want to sort child table but I can't because if Order exist in Relation then Order in child table is ignored.
>
>Is there any way to sort child table?
For this reason (because of the problems you mention), I don't use parent-child relations between grids. You can use one of these alternatives:
Use the SET FILTER command in the child table.
Use a parameterized view in the child table.
The second alternative should be faster, especially for larger tables.
In both cases, you have to update the child table (change the filter, or requery() the view), when you change the parent record.
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)