field display in pivot table

  • Thread starter Thread starter Sherry
  • Start date Start date
S

Sherry

I have created table with a "look up" field called Products. I have then
created a query...pivot table so I can easily add the tons for each product.
However, when I drop in the Products field, it only shows the Primary Key
field instead of the NAME of the product. I've searched the HELP files and
have not come up with anything.

Can anyone help?
 
I don't quite understand what you are suggesting to do. But what I do
understand is that the hours of creating this database (full of look-up
tables) was now wasted. I am a "self-taught" Access user and have learned by
trial and error and the mystical/magical "HELP" menu. I guess it's
officially time to take a course in Access.
 
You should have a table that is referenced in the lookup properties of the
Product field. Add that table into your "then created a query" so you can
reference the displayed product name.

Some developers are just fine with lookup fields but they can be very
confusing because you don't generally store what you see or see what you
store.
 
Thanks, that worked
--
Sherry


Duane Hookom said:
You should have a table that is referenced in the lookup properties of the
Product field. Add that table into your "then created a query" so you can
reference the displayed product name.

Some developers are just fine with lookup fields but they can be very
confusing because you don't generally store what you see or see what you
store.
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm
 
Back
Top