Hi, I'm trying to load a list of items from a spreadsheet into listview, which I can do successfully. The spreadsheet has two columns; Column 1 is the description of the item as seen on the screen in the list, which can be several words. For example, "Invalid bar codes", and the second column has an abbreviation of that that I want to use as a key for a second spreadsheet, eg, "Invalid".
I know I have successfully loaded both columns into two different lists, ShowData and HideData, as either of them can be selected to be loaded into listview. But what I want is that when an item is selected in listview, the 'HideData' entry corresponding to the selected entry in Listview is passed to the next screen. Eg, when they select item 'Invalid Bar Codes' which is item 7 from the list on the screen which comes from 'Showdata', I want 'Invalid' which is item 7 in HideData passed as a parameter to the next screen. (note: the hidden column is not necessarily just the first word of the shown column). I can't work out how to identify the corresponding entry in the other list of the one selected on the screen.
Can anyone help? Any advice gratefully received.
Thanks,
Mike