We help IT Professionals succeed at work.

How to Tag List View Records With Multi Field Indexes

Buck_Beasom asked
I have a table with a composite index that uses 2 fields to identify a record. Ordinarily when the user clicks in a List View, I use code like this to establish the "tag":

objListViewItem.Tag = objCampaignList.DataReader.Item("RevLineID")

This works because "RevLineID" is the primary key in that table. Since I need 2 field values to identify the record in the table I am working with, I am thinking about putting the second field in a column with a zero width so I can access it as a sub-item in the List View. But I'm betting there is a more elegant methodology, as I can't be the first person to use a composite index.

Any suggestions?
Watch Question

Software Architect
Top Expert 2005