Handling ComboBox control in MFC

Hi,

I’m developing a database application using MFC. In few areas, i’m using Combo box control. In that i’m populating the list of employees. Whenever a user selects an employees name from the combo box, i just need to fetch the concern employee id without writing a second SQL statement just by passing employees name in the where condition. Is there anyway to handle employees id and employees name in a combo box when i populating itself.

Kindly provide me an help or sample code which willbe helpful for my problem.

Thanks in advance.

Manohar