I have a database where bidders can place bids on types of items rather than specific items. At the end of the auction, I need to run some sort of query to allocate specific items to specific bids so that I can create a report to inform successful bidders of their allocated item.
Right now...