Hi, I have 3 tables of Products, Category and CategoryProducts for mapping. And Vendors table with ProductID foreign key to indicate if the product is available.
So the relations look like; [Vendors] <--> [Product] <--> [CategoryProducts] <--> [Category] In Product mapping file, I defined a bag for Vendors and a join tag to fetch only products with vendors available. When I fetch all products only with available vendors it works fine, however, it returns all products regardless of vendor availability when I fetch products in a certain Category. How can I get products from a category that have vendors available? Thanks. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
