Filter Based on Value in Subform
Posted on 2012-04-01
We have a primary form of products with a Subform called Products_Pricing that is a one-to-many. In the subform there is a filter that has the CustomerID. How can we filter the primary form based on the Subform value???
For example, there are 500 total products, but some products are sold to Customer A and some are sold to CustomerB, whereas some are sold to both customers. Our subform has a customer field. If the users use the built in filter, then it just filters the customers within the "one product". So if CustomerA has pricing set for 40 products, they want to be able to say just show me Customer A Active Products.