Sorting and Grouping from a lookup wizard field

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

Guest

I created a table that uses data from another table to create a lookup list.
I can query my records and even calculate them. But when trying to create a
report and group on one of my lookup list fields, it just displays the
primary key and not the actual data.

How do I display the data that I selected when creating the record? All
other lookups are displaying fine. I didn't change any properties to the
field.
 
Dave,
If I understand your question . . .

When you create a lookup list, it is the primary key of the linked table
which goes in the lookup field. If you want to see the description field, you
will need to include the lookup table in the report also and include that
field on the report.

hth,
James
 
I created a table that uses data from another table to create a lookup list.
I can query my records and even calculate them. But when trying to create a
report and group on one of my lookup list fields, it just displays the
primary key and not the actual data.
Click to expand...

Exactly. Despite Microsoft's effort to confuse you with its so-called
Lookup Data Type, that's exactly what your table contains: the numeric
foreign key value. That fact is concealed from your view by the combo
box.
How do I display the data that I selected when creating the record? All
other lookups are displaying fine. I didn't change any properties to the
field.
Click to expand...

Create a Query joining your main table to the lookup table, joining
the lookup table's primary key to the field in your table. You can
then include the text value from the lookup table as a field on your
report.

Note that it is NOT necessary to use Lookup Fields... ever. See
http://www.mvps.org/access/lookupfields.htm for a critique.

John W. Vinson [MVP]
 
Back
Top