Just to clarify...you said:
The user can choose one value, more values or all values, whatever they like, in the pick order they like.
Then you said
Is there a way to sort the values within the global field?
The fields that are checked are creating a list in the order they are checked. Then what sort order would you like?
Thanks for your time and response Steve,
Well, if I use a SetField with "from - until" the sort order has to be alphabetical, otherwise nothing is find. What i mean is this; if the pick order from the checkbox is e.g. "Internet" and "Computer", the search is based on from "Internet" until "Computer" and that results is no records found. The search should be from "Computer" until "Internet".
I know that the checked fields are stored in the way the are checked, but for the find I need them alphabetical.
Set Field [ Table::GlobalCheckBoxFieldHere ; FilterValues ( ValueListItems ( Get ( FileName ) ; "ValueListNameHereInQuotes" ; Table::GlobalCheckBoxFieldHere ) ) ]
Will reorder the selected values in the global field to match the order of the values in the value list. If this is a use values from field value list, the values will automatically be listed in alphabetical ascending order. If this is a custom values value list, you will need to manually order the values in the value list to be in this order.
Thanks (again) for your time and effort Phil,
This works perfectly. (That I didn't think of that. I have been struggling with this issue for hours).
By the way, I used your solution for checkboxes in Adventure 2.