I want to build a result page. I have two tables<img src=../images/dmxzone/forum/icon_smile_tongue.gif border=0 align=middle>roducts and productdetails

Product has for example the following recordsets:
ProductID, productname, price
1, Car, 500
2, Ship, 600
3, Plane, 200

ProductDetails has the following recordsets:
ProductdetailID, ProductID, Color
1,1,red
2,1,green
3,3,blue

Now i want to display a result page. On this reslt page you will see the three Products and - if there are variations in color - a listbox including the available colors. If there are no productdetails you should only see the name of the product and no listbox. So some of the products have listboxes on the resultpage and some have not. Any hints and tips are very much welcome <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>



Boris Boy