selecting value from a drop-down menu

[SQLjunky]

Hello,
Contrary to what my screen name indicates, i'm actually quite new to SQL.
Having said that, I'll get right into my problem.
I'm trying to query an mssql database to return to the value that the user inputs through a drop-down menu in the databases GUI front-end (bugzilla actually). For example, a product is selected in a drop-down menu, and, depending on the product chosen, a second drop-down menu becomes active, containing a list of components attributed with that product. So, my query, in general looks like this:

SELECT product_id, component_id FROM bug_database WHERE bug_id = x;
 

the problem is is that these two values are returned as integers, representing the number in the list that they were chosen from. For example, if the product the user selected was, say, Firefox, and Firefox was the third item in the product list, the product_id that this query would return is simply: 3

How, instead, do I get the query to return Firefox, the item associated with the third item in the list, instead of the number in the list?

I appreciate any help I can get.
Thanks,
_ramy

[pbmods]

Heya, Ramy. Welcome to TSDN!

Please use CODE tags when posting source code:

[CODE=sql]
SQL code goes here.
[/CODE]

I'm going to go ahead and move this thread to the MS SQL forum, where our resident Experts will be better able to help you out.

[Shashi Sadasivan]

So is the name Firefox stored in a different table?

[ck9663]

something like:

SELECT product_id, component_id,thefieldthatholdsthebrowsername FROM bug_database WHERE bug_id = x;

then in your GUI, display the thirdfield...