I'm stumped. If someone can help me I'll give you 10,000 GT casino dollars. I have 2 tables: inventory and shopping cart. Inventory: #ID #Product #Price 1 Table $100 2 Chair $50 3 Keyboard $20 Then in a shopping cart of a client: ClientNo #ID 1 1 1 2 1 3 2... 3... Which means client 1 has purchased items 1,2, and 3. Now here's the problem. At the end of the user's checkout, I'd like to dispaly the price of each product he/she purchased. I can easily do a loop in the recordset and run two subqueries, i.e. get a set of all the products the user ordered, then for each record, do another query on the inventory database to return the price. However, I know from school that there is a way to do a subquery without a loop. Something like: Select price,product from Inventory where ID = 'theID'. The problem is, theID is a recordset, NOT an individual record! I'm not sure what to do? Any help is appreciated. Wanna kill these ads? We can help!