Erdinc, if you want to see the child records for one parent in the Order_Date order, then you need to change your FK index to FK + dtos(order_date). That way the relation will still be used to find the correct Child records and they will show on the form in your date order.

If you change the table order in the DE the grid Linkmaster/ChildOrder fields will simply re-set it, or you will find your grid not working correctly (depending on various internal actions).

HTH
Barbara

>Hi Erdinc!
>
>Yes, just set the desired order in DE of your form...
>
>Have a happy day
>Vladimir Shevchenko
>
>> Is it possible to view the records in the child table, on a 1 to many
>form,
>> ordered by Order_Date without breaking the relation ?