Sorting Sub Summary Part by Field
I've posted this question previously but thought by adding a picture of my relationship table, it may help. I basically want to let the user have some control over the way records are displayed on the report by numbering them 1,2,3....
At the moment my sub summary part is sorted by PK_Room_ID, I thought I could just sort by a field in which the user assigns a number to the record.
Any suggestions would be much appreciated.