Hey Guys,
I thank you all for replying previously to my question regarding "getting the default values in select boxes to be dynamic". I have solved that problem and it is working well!
I've come back to you with another problem. Any suggestions would be a great help!
I have a table with the following columns (Position Name, Position Order). This "Position Order" is the order in which all the values would be displayed dynamically. This is not the primary key.
So, my values (Position Order) range from 1 to the maximum number of rows inserted. I have some functions to refresh my position order in case, I delete any row. Now, I would want one form which makes the user change the order to be displayed.
Example: From Database if values are like this:
Positiion Name Position Order
A 1
B 2
C 3
D 4
If I want to change the order to be displayed like:
A
C
B
D
I have to change the position orders and ensure that I do not have any duplicate values in there.
Can anyone suggest me how to do it? What kind of form should I be thinking..?
I had thought about having 2 multi-row select boxes: with one displaying all position names (order by position order) and a button to transfer the order with which I would like the values to appear in another multi-line select box. But, how would that work? How can I get all values from a select box and how can I add values dynamically to a select box from one box to another?
Do you get my question? Sorry, If I am not able to put my query properly.
Thanks for your help and your time in reading my query.
Amy.
