>Afternoon
>
>I am having a bit of difficulty, and would like someone to confirm my property settings in the Grid control.
>
>I have ParentTable and ChildTable who have a one-to-many relationship linked via field - CL_REF. The grid's RecordSource is "ChildTable".
>
>I want to grid to just display the matching CL_REF records from ParentTable, so I have set the following properties:
>
>ChildOrder = "CL_REF"
>LinkMaster = "ParentTable"
>RelationalExpr = "CL_REF"
>
>Is this correct?
>
>Thanks
>Kev
Kevin,
If in code you mean
select childTable
set order to tag cl_ref
select parentTable
set relation to cl_ref into ChildTable
Then it's correct. However if you have a DE and in DE childTable order is something else then your grid might display nothing.
Cetin