search for: itemnumber

I''m playing with an online store.... I have an orders table which holds orders (pricing, statuses, etc). An orderDetails table which holds detailed line items (itemNumbers, unit prices, etc). Each order can have multiple shipping addresses, so I also have an addressbook table. Each orderDetail is tied to an addressbook entry via the ordernumber and addressbook alias, but this doesn''t seem to work for me. ------ class OrderDetail < ActiveRecord::Base...

...s the results are in. but if i look in a category (search on that category) then i want to see that item there obviously only the once that it is there. so i've got the hierarchy part..but its getting items to be in multiple categories. i can put them there as duplicate entries of that itemNumber, however when i search i dont want to get back the 7 times that one item is used.. i dont mind if its in 7 categories and they each show one usage, but i'd like for my total hit count to reflect just that this item exists once... i could iterate through the whole Hits list and put them into...