thnx Fabio

is any way to solve this ?

anand


Solution A:
minimize space, but can slow down the grid refresh if ChildTable is long and filtering is very selective

SELECT ChildTable
SET ORDER  TO myOrder
SET FILTER TO rowParent=parentTable.rowField && this simultate the RELATION

Solution B:
use a filtered index

SELECT ChildTable
INDEX ON myOrderKey FOR rowParent=parentTable.rowField && for max speed use a old idx not compact
* when parentTable.rowField change, you can redo previous or do next command
SELECT ChildTable
REINDEX

Solution C:
use a query or a view for rebuild the filtered ChildTable

SELECT * FROM ChildTable WHERE rowParent=parentTable.rowField ORDER BY myOrderKey