Returning multiple values from database

[inkfid]

How do i create a db lookup that will seperate and store a varible based upon common factors that can be called upon later?

i.e.

My entries are office locations the common factor for each will be which region it is in.

When pulling the Location it needs to create 3 Regions (EMEA, APAC & AMERICA) and place the Locations into the relevant Region.

Essentially I (as the programmer) am interested in the Regions, but the user is interested in the Location.
The list of locations are populated in a drop-down box that is refferencing and Access DB.

I hope this makes sense?
I'm writing in aspx using visual studio 2008.

 

[jtabernik]

It sounds like you want to return a list of Locations to display in a drop down. When the user selects a Location, you want to get the Region the Location is associated with--that is all you care about.

You can write a query that would get Location in one column, and Region in the other. Populate the drop down with Location as the display value, and Region as the code value. When the user selects the Location, you can get the Region as the drop down's value.

Let me know if I am misunderstanding your goal here.

John Tabernik
The Eclectic Techie