I have a question. I have a Magento Enterprise and have two store views. Each store view has slight different products. What I want is when I am in a store view lets say one of them is called USA and I do a product search I need the search box to realize I am in the "USA" store view and only search for the products that are setup within that store view.
My question is what mysql table would the relationship be stored that connects a product to a specific store view? Or how would I alter the query to take into account what store view the end user is currently viewing?