On a report how do I display the text not the lookup value?

I am trying to generate a report from information stored in table#1 that
looks up organization names from table#2. When I include the organization
field from table#1 in my report, the report displays the numerical value
stored in table #1 not the actual text of the organization name stored in
table#2. How do I get the
report to display the text value from table #2? I'm just getting started
with access and tried finding this in a book I have and on the help topics
but to no avail. Any help would be greatly appreciated. Thanks.