result set database query

[Robert Mann]

I get the result set from a query (id and name) these are put into a menu
(only name showing)
now when you select a name I want to pass the id that goes with the name to
a new query
any ideas how to do this?

1  bill
2 john
3 rob

select rob would like to pass 3 to new query

Thanks
Robert Mann