Problem with pivot table on a form

[joecosmides]

I have a database with a table for my sales team. It is set to
autonumber and every time I create a new sales employee they are
generated an ID from the autonumber. My problem is that when I create
a pivot table, it shows the employee number and not the name. On the
form I've set it up correctly by adding a combo box that looks into
the table and provides the first name. When I set the form to single
form, continuous form, or datasheet it works fine and shows me the
first name. Only when I set it to pivot table does it become a problem
and only supplies me with the sales person's autonumber ID. I can't
figure out if there is something else I can do to fix this. Any help
would be great.

Thanks

 

[Rastro]

I think whit a join to the first-name field it could work but I must see the
SQL sentence of the pivot table.