Sorting Multi-value field view, and doc view of the same data that contains special characters

Hello all,

I have a field that is a multivalue field on one form (say FORM1), and a form document (FORM2) gets created for each value FROM the values contained in that multi-value field from FORM1. One view (VIEW1) contains the multi-value form field (SELECT Form=FORM1), categorized, view values as seperate entries, and one of the values contained in the multi-value field is called “* N/A ". The other view (VIEW2) contains contains the single values field (SELECT Form=FORM2), categorized, sorted on that field (from FORM2), which includes the value " N/A *” also.

VIEW1 (multi-value) looks like this when sorted…

  • N/A *

Value1

Value2

Value3

VIEW2 (single doc) looks like this when sorted…

Value1

Value2

Value3

  • N/A *

What is the deal with that??

Within a multi-value field, the sort parameters for special characters are different than getting the value from a field that contains one specific value???

Any ideas or suggestions welcome…

Sorry if reading this confuses the issue more, or is not clear…

Any help is appreciated…

Mick