Show actual Text and not Primary Key Number

T

TKM

Most of my tables now carry the Primary Key number in certain tables for
selected data in CBO. I need to extract the actual text that is associated
with the number listed in my table and show it on my reports. I know it can
be done in a query but don’t know how. Can someone help me out on this one?

Thanks again
 
J

John W. Vinson

Most of my tables now carry the Primary Key number in certain tables for
selected data in CBO. I need to extract the actual text that is associated
with the number listed in my table and show it on my reports. I know it can
be done in a query but don’t know how. Can someone help me out on this one?

Thanks again
Click to expand...

Create a Query by adding your main table to the query design window, and then
adding all of the needed lookup tables. Access should join the lookup tables
by their primary key - if not, join them. Select the looked-up value from the
joined lookup table.

Base your Report on this query rather than directly on the table.

John W. Vinson [MVP]
 
Top