I have two tables.
User enter items for PO in line in a portal in the PO Header. Nice and basic.
But sometimes a user want to reorder the lines.
What I do is I assign each line a number (in tens). Line one is 10, line two 20, and so on. The portal is set to sort by this field.
If they want to reorder I give them access to that field and they can adjust this number. Such as change line 30 to line 15. A through back to my old Computer Days (1980s).
I am thinking of writing a routine with up and down arrows on each line.
Before I embark I was curious if anyone has done this before and has comments, advise, or even a canned solution I can buy.