I know the subject is a little confusing, i'm sorry about that. I have a couple of tables that are related. Products and Orders. i have a foreign key in the orders table from the Products Table (ProductID) ok i want to display things from the orders table in a table on an asp page, i can do this fine... here's the problem. there's a field in the Products table i want to display it's called manufacturers, how can i show the manufacturers name in the orders table based on the ProductID foreign key? make sense? for example i want to make a page and say here's all the porducts that were ordered from this manufacturer, and this one and this one... for this particular order. right now i am displaying just the ProductID number not the manufacturer name. So i want to replace the ProductID number with the corrosponding manufacturers name from the Products table. Jeeeezzzz i just gave myself a headache... Thanks in advance.