Hi there
How can we trigger, when a filter is set on a DataGrid-Table?
Background: we have a parent-child-scenario. For example orders => orderdetails. Both are schown in separated datagrids on the same form. When a user selects an order in the orders-datagrid the according orderdtails are shown in the orderdetails datagrid (works over a relation). Now the user wants to filter orders depending on a filter criteria upon the orderdetails form. So the user sets a filter on the datagrid of the orderdetail-form and now I want to react on that and add an additional filter on the parent form (something like this: …where order_id in (select order_id from order_details where …). Maybe there is a better way to achieve this. But at least I’m not aware of it.
Thanks in advance for any suggestions.
Best, Roland