Query to Look-up Value in place of SNo

S

sunilkeswani

Hi,

I need help on this urgently. I have synchonized combo boxes on a form,
which show the value, and when submitted, the ID of the value gets
captured. How do I create a query which will display the values
instead?

EXAMPLE

State_ID State
1. OHIO
2. NEW JERSEY
3. NEW YORK
4. GEORGIA
5. CALIFORNIA

Now on the basis of the above, if my combo box displays Ohio, New
Jersey, Ne York, Georgia, California , and when submitted, the DB gives
me- 1,2,3,4,5, with reference to the entries....how do i create a query
which throws out the actual names of the state?

Please help

Regards
 
Top