I have a database table which I am using to populate a combo box. What I would like to do is have the user select an item, and make it so I can get the primary key when the user selects the recognizable text. I realize that I can create another combo box and use the index property to get the related primary key, but this seems like a hack to me.

Does anyone have a better way of performing this function? I have to do this sort of thing all the time. I used to use a third party control which had a tag property for each item, but I don't have that option here. I need to do it in straight MS VB6. I was wondering if anyone has used list view control to do this.

Looking forward to finding out how other people would solve this.