Hello.
I'm facing a problem with table box sorting and I would like to check if its a "normal" behaviour.
I've a table box with one field. This field is sorted by an expression that depends on the sorting option selected by the used. It's something like this:
Pick( vSortingOpt,
Sorting expression 1,
Sorting expression 2,
Sorting expression 3,
Sorting expression 4
)
Each sorting expression work just fine, the problem is that vSortingOpt changes from 1 to (e.g.) 3 the sorting in the table remains the same. It will only be sorted by expression 3 when a change in the selected data related to the field shown in the table is made. It seems like table box is only updated if a change in the data to be shown occurs and not when any changes occurs. Of course Chart Straight table works fine, the problems is I'm not able to use it because I need to edit a text input field.
Have any experienced this problem?
Regards
