Report displaying numbers instead of information

[Guest]

I have a form I created to enter info into a table. On this form, there are
combo boxes that allow a user to enter info from a list. Each list is also
seperate table. In the form, the results are displayed the way I want them to
be but once I create a report based upon the table, those fields that I use
Combo boxes for are displaying numbers instead of information. I have tried
editing the properties of the combo boxes but the Primary Key field is still
the only one that will display. Anyone have any suggestions?

Ex.
Table 1
Entry (P.Key) Field 1 (Last Name)

Table 2
Entry (P.Key) Field 2 (Projects)

Table 3
Entry (P.Key) Field 1 (Last Name) Field 2 (Project)

Form 1--Based on Table 3
Combo 1 (List provided by Table 1, Last Name--Stored in Table 3 Last Name)
Combo 2 (List Provided by Table 2, Projects---Stored in Table 3 Project)

Report 1---Based on Table 3
Field 1 (Last Name) is displaying "1" instead of "Adams"
Field 2 (Project) is displaying "5" instead of "Dolphin"

I looked at my tables and the info is being stored as a number in there also
even though it displays with the "Name" and "Project" on the form. Do I have
to set up the relationships for the tables? If so, how would I do that as far
as the type, and which way do the arrows need to point? Thanks for your help!

 

[Duane Hookom]

You can either use combo boxes on your report or add the lookup tables to
your report's record source.