I have a drop down on a page (&#060;select>&#060;/select>). Now i am populating this menu with <BR>&#060;option value="prod_id">prod_name&#060;/option><BR>now "prod_id" has to be the value siince on the next page the user is to be shown information about some part related to this product and i need it&#039s id to search in the databse with. Now i want to show the select product&#039s name also on the next page and not just the parts details. Also the prod_id happens to be the foreign key in the parts table in the db so to get it&#039s(product&#039s) name from the db would neccesiate another sql query which i dont really like the idea of.<BR><BR>Please advice.