As I add records to a Grid using the design-time RecordSource, RelationalExpr, ChildOrder, and LinkMaster properties for data used for grid. As I add records to RecordSource records the data rows of grid are not sorted as I want (below is diagram of Parent->Child table relationships used for Grid). How do I do this?

Parent Table.Relational_Field: DD_ear.ar_rcn

Child Table.Child_Order_Field: DD_earappdwg.rd_rcn


Grid RecordSource: DD_earappdwg
RelationalExpr: str(ar_rcn)
LinkMaster: DD_ear
ChildOrder: rd_rcn

I Want to sort the Grid on DD_earappdwg.rd_dsort field as records
are added to DD_earappdwg table.

Fred Z