I work in the health industry. Our doctors have multiple provider numbers - one for each location where they work.

I need to be able to select a provider number from a combo box but the number itself is meaningless. I need a second column containing the location. Something like this:

Location............. Provider No.



Main Road.............123456A

I want to select the row but only have the provider number show in the field.

Thanks for any help you can provide

There isn't such a capacity. However, for something approximating the desired result, see: https://www.msofficeforums.com/word-...html#post46903

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]