I posted something in the General Help section about Custom Sorting. Thought maybe this might be a better place for it...
I'm trying to allow users to custom sort records from a database - and i don't mean sort by different columns - i mean move items around (like 1 after 6 etc). I've been doing it with a SORT column that i can change the number of each item etc.
There's more of an example in General Help... but my problem is it takes a lot of database hits- everytime i move something i have to move the other items in the table to make room for it.
Has anyone encountered a similar problem or come up with a better solution?
sm
