im very new at asp, so hope this isnt too silly a question!. I will try and leave out the needless details.<BR><BR>i have one table called product, and another called cart. There is a relationship set up via a field in both tables called productid.<BR><BR>Now lets say i use a select statement on the cart table, and it returns 4 different records, each with a productid and qty.<BR><BR>I want to repsonse.write the results while not at the end of recordset.. i kno how to do this. but how would i also show the product_name (which is in the product table).<BR><BR>do i have to pass the productid returned from the select statement on the cart table into another select statement on the product table? cuz i can think of some problems with that.<BR><BR>thanks in advance!.. sorry if this sort of question is a pain, just ignore it if it is asking too much!