Query to Look-up Value in place of SNo

[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

 

[Marshall Barton]

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?

Create a query and add both the table with the stateID
foreign key and the states table. Make sure the join line
is between the correct fields. Then add the state name
field to the query's field list.