In the Item form I am trying to add a Sublist Safe Search to find all the Open Sales Orders this item shows up in (Including as Components of Kits that are in the Sales Order).
So far my solution shows Open Sales Orders with the item, but any Open Sales Orders where this item is a component of a Kit (so not technically in the sales order) dont show up. How can I make this Safe Search find Open Sales Orders where the item is located in there and also show it where All Kits that contain the item also show up?
Ive tried looking into the Member's field, but It doesn't show up as a filter. And trying to use "Component of" in the Available Filters tab make it so it has to be an AND filter. (So the item name must be the original item im looking for AND its a component of the itself. Obviously doesnt work...)