Hi,<BR>I am developing a ecommerce website and the requirement is to <BR>display a popup box which displays colors available for a particular product, <BR>so all the products will have a dropdown box which displays colors<BR>available.<BR>there is a table called products and productid as primary key<BR>and a table called colors <BR>which has <BR>1)colorid and<BR>2)color <BR>as columns in the shopping database<BR>i have created one more table linking both the tables Products and Colors<BR>called ProductColor<BR>which has <BR>1)prodid<BR>2)colorid<BR>as columns and composite primary key.<BR>now the problem is to get this information onto the products page.<BR><BR>any suggesionts are welcome even any alterntives to achieve the same.<BR><BR>thanks<BR>