I have a need to filter a datagrid or datalist on miltiple related table memberships. The scenario is like this.
Primary table is Auctions. Each auction is setup internally and has vendors and customers related tables.
Customers should only see auctions they have been added to. Multiple customers can be a part of a single auction.
Vendors should also only see auctions they have been assigned. Multiple vendors can be on a single auction.
I'm not sure how to write this as an expression for the datasource invoke filter.