Look-up Table Issue

[Novice1]

I have a main table which collects address information for several people. Each state field (number) looks up the information from another table, which lists a 2-digit state abbreviation and the full state name. No problem.

However, I don't know how to pull the 2 digit state abbreviation into the query. I can only pull the number, in the state field, into the query.

While I can simply list the abbreviations in the state field, I thought it would be easier for the user to see the full state name and abbreviation.

How do I extract the state abbreviation vs. the associated number?

 

[plog]

2-digit state abbreviation

That made my head spin. I know what all those words mean individually, but not when put together like that.

Can you post an example? Show what your data is like in your tables, then what you expect to be shown.

 

[pbaldy]

On a form I'd use a combo that displayed the text but stored the number (with the number hidden). In a query, you'd add both tables with a join on the number field, enabling you to return the text values.