Grid showing all child records

[ChrisRChamberlain]

In the Activate() event of a page in a pageframe, a relation is set between Parent and Child table.

A grid is added from a class library using THIS.AddObject(), LinkMaster, RecordSource, ChildOrder and RelationalExpr being correctly set in the grid class.

The relationship works, but the grid displays all child records, starting at the first child record.

I have tried setting the relationship up in the DataEnvironment as opposed to code, but it makes no difference.

SET FILTER TO expr is one workaround but at a performance loss.

Has anyone any better ideas?

Chris :-(

 

[ChrisRChamberlain]

Sometimes the answers are so obvious you just can't see them!

SQL Statement with NOFILTER does the trick.

Chris :~/