Quote Originally Posted by pdk5 View Post
first Site1
Site3
Site4
second Site4
Site5
Site6

Here, Site1, 3, 4, are supposed to have column 1 as "first". So if i select, site1, we know the corresponding column is "site1". Lets say user selects "site3". Then user has to deduce that column 1 is "first", eventhough in the list it appears as no text.

Basically, if user selects, 1st, 2nd or 3rd row, the function needs to derive "first"...And do some processing based on this.

Otherway, is to explicitly store the column info for each rows... But it maynot look nice

The function is something like this:

OnSiteDB{

if(selection is 1st, 2nd or 3rd row)
coulmn_text = "first";

if(selection is 4th, 5th or 6th row)
column_text = "second"
}

Sorry if im trying to complicate things, or asking vague thing.
You find an empty second column, then read the previous second column until you find one that's not empty any more.