Cetin,
Sorry to say, but your solution did not work; when I changed ChildOrder back to rd_rcn it worked showing child table data in grid (albeit, not correct for Grid displayed rows sort order).
When I used your concatenated - 2 field - string index tax from RecordSource (Child table) nothing displayed in Grid.
Here is implementation of your Solution that did not work.
Tables:
Parent (dd_Ear)
Field: ar_rcn (Integer)
Index (tag): ar_rcn (Field ar_rcn)
Child (dd_Earappdwg)
Fields: rd_rcn (Integer), rd_dsort (Char)
Index (tags):
rd_rcn (Field rd_rcn), rd_grdsort (Expr: Str(rd_rcn)+Alltrim(rd_dsort))
DD_ear:
Form (with Grid) Load() method:
USE DD_ear order rd_rcn share
USE DD_earappdwg order rd_rcn share
SET RELATION TO ar_rcn INTO dd_earappdwg IN dd_ear ADDITIVE
Form Grid Properties:
ChildOrder: rd_grdsort
LinkMaster: dd_ear
RecordSource: dd_earappdwg
RelationalExpr: str(ar_rcn)
Through Form (.SCX) I have function to add records to child table (dd_earappdwg). That is when child records should freshly
display in Grid (existing child records are displayed in grid when parent table that links them is pointed to via navigation in Form).
Fred Z
Don