Hopefully a quick one : I have a products table and in the view I am showing these products as well as a sidebar to "filter" the products by team, size, color etc (which are all attributes of other join tables). What is the most efficient (in terms of best practice) way of getting the filtered list in the sidebar? I want to minimise the hits on the database. Is it possible to just grab the products and then just show the distinct "teams" for example (considering the join association would have already grabbed the team name)? Thanks, Rob -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.