I need to filter a portal using information from a table then filter that information again with a child table. ie. One of the portal (Parts) needs to show expired shelf life parts that are not quarantined. Shelf life is in one table and the location is in a child table. There are more than one portal on the layout and the layout is not linked to the Parts table.
The structure looks like :
Dashboard -> Parts -> Part_Transaction
Dashboard -> ... -> ....
I have tried all kind of things, but the second filter will not work.
Thank you for your help!