>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
Fred (or Don ?),
Hard to understand exactly.
As I understand DD_earappdwg.rd_rcn is a char type field and you want it to be sorted by DD_earappdwg.rd_dsort (datetime ? - will assume it's) :
Create an index in table DD_earappdwg. ie :
index on rd_rcn+ttoc(rd_dsort,1) tag mySorter
Grid RecordSource: DD_earappdwg
RelationalExpr: str(ar_rcn)
LinkMaster: DD_ear
ChildOrder: mySorter
Cetin