I have two lists dynamically generated from a form. EG
List one (text1,text2,text3,text4)
List two (2,4,1,3)
The first list is created by the user selecting items on a form using the checkbox. On selecting the item, he/she then enters an order number into a field adjoining the checkbox.
The form is submitted and I have two lists, as above. Text1 has a list order of 2, text 2 has a list order of 4, text3 has a list order of 1 and text4 has a list order of 3.
The objective is to create a new version of list one, where the order of the elements is 1,2,3, 4 - vrs their current order of 2,4,1, 3. The reordered list is then used to create a table listing of list1 elements, ordered by 1,2,3,4.
Can someone give me a pointer as to how I might do this. First thought is to create a two dimensional array, sort it and then generate a new version of list1 ?
Many thanks for any help