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