How to Tag List View Records With Multi Field Indexes

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?
Buck_BeasomDatabase DesignerAsked:
Who is Participating?
 
SwapnilSoftware ArchitectCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.