1)How do I access a field in a different recordset? For example I have a itemsOrdered table that consist of 3 fields (ProductID, quantity, orderID). I want to get the product name from the Products table based on the product ID. Sesions are involved also. How do I access the data?<BR><BR>2) I want to send the the 3 fields and the product name in an email using CDONTS, I only having it working if I only buy 1 product. How do I get all the info based on session, productID, ect.?