Report displaying numbers instead of information

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
You can either use combo boxes on your report or add the lookup tables to
your report's record source.
 
Back
Top