is it possible to filter the parent recordset based on values of the child recordset? for instance filter Suppliers based on those who have Orders from New York.
