Hi,
How to use SQL condition to apply SQL condition to the data for child table preview Pop-up?
Currently, for child table, if we want to filter say id = 0,
we will put at the before SQL query event for the child table:
$v_where = " id = 0 " ;
$strWhereClause= WhereAdd($strWhereClause,$v_where);
But when we mouse over the child table at the master table, the preview popup will not show the filtered data of the child table.
it will show everything. Only after clicking the child table, then the before SQL event is applied,
thus user who see the preview child table is different when they actually click the child table.
Any help is appreciated!
acp