field display in pivot table

[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?

 

[Duane Hookom]

Lookup tables are frowned on by most of us MVPs that have been around for a
few years http://www.mvps.org/access/lookupfields.htm. Consider adding in
your lookup table to a query and use this as the source of your pivot table.

 

[Sherry]

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.

 

[Duane Hookom]

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.

 

[Sherry]

Thanks, that worked
--
Sherry

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