Pivot Table Help

[jodyblau]

I am attempting to learn to use pivot tables.

I have noticed that if I have used the Lookup Wizard when creating my
tables so allow the user to select from a list of choices when entering
data, this causes a problem with the pivot tables.

When I try to use a field like "Customer_Name" and drag it onto my
pivot table, it display's the ID for that Customer instead of the
Customer's name.

Is there a way to change the pivot table so that it will display the
name rather than the ID in this situation?
Thanks,

Jody Blau

[Ed Robichaud]

Your lookup/find combobox is probably showing the CustName but really
operating on CustID. Look at the properties of the combobox and you'll
probably see that the 1st column (CustID) is set to 0" width (to hide it).
Make the recordsource of your pivot table a query that contain the actual
CustName as well as the ID-Name lookup.
-Ed

"jodyblau" <jo******@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...

I am attempting to learn to use pivot tables.

I have noticed that if I have used the Lookup Wizard when creating my
tables so allow the user to select from a list of choices when entering
data, this causes a problem with the pivot tables.

When I try to use a field like "Customer_Name" and drag it onto my
pivot table, it display's the ID for that Customer instead of the
Customer's name.

Is there a way to change the pivot table so that it will display the
name rather than the ID in this situation?
Thanks,

Jody Blau