View Full Version : Sort Items

February 16th, 2011, 05:42 AM
I'd like to offer a field to enter a preferred order, i.e.,

Item1a=Red Item1b=six Sort1=2
Item2a=Blue Item2b=four Sort2=3
Item3a=Black Item3b=three Sort3=1

To produce the result:
Black three
Red six
Blue four

There could be 10 or more items, each with 3 associated fields plus the sort field. How can I build a rule that will allow the end user to dictate the order of the result?