Complex DB/Reusable Issue

Hello all, this is a part of my DB:


My question is: How can I make my Repeating Group of type Product within a Reusable Element show only the products whose quantity in the Inventario data type is greater than zero for the selected branch in the Venta page?

I’m stucked here (below), as I cannot figure out how can I filter per current page branch, as the reusable is a product sales data type.


Make an inventory data type…have a field that is the availability (number) and a field that is realted to product…then search for inventory and constrain by availability greater than zero and in dynamic expression of search use each items product…your repeating group data type should be product.