I have a table that stores data of things to do at various locations it can store up to six locations(location0 to location7) now at each location there can be 3 different thing to be done.what i would like to do is this have 4 text boxes
location item item1 item2 now if the items are at the same location then display then on the same line in each textbox else for every different location we would start a new line. eg
location item item1 item2
location0 1 2 3
location1 4 5
location2 6 7
so at location0 we are going to do all 3 items,at location1 we are only going to do item1and item2 and at location2 item and item3.etc.etc.