Sort a subfield

Sort a subfield

Hi,

I want to be able to sort a sub field but there seems to be no options to do this, if I create a sort in the original report will the sub field also sort by the same criteria?

Basically I want to be able to create a call sheet that list times that people do various things in a day. The order of things might change and I don't want the user to have to delete rows in order to insert information.

Basically the call sheet form holds multiple subforms with different information. The shoot schedule lists the various activities of the day and is sorted by a decimal field so that if the user wants to change the order they just alter the number in the decimal field so it is between the two other rows they want to move it to.

Is there a better way to do this?

It would be great if there was a drag function within subforms so that you could re-order manually. I have attached a pdf of the CRM version of the form so you can see what I am talking about.

Thanks