Hi everyone,

Big one for you here!

I have a file 'results' with four records in wich I have a field 'ResultName'. Here are the four ResultName values:

1- A

2- A+

3- B

4- B+

In another file, I want to display a list of possible results, but the '+' in some 'ResultName' seems to mix up the list and I have only 2 choice instead of 4...(A and :

Can anyone help me?

Not only does your related value list refuse to acknowledge A and A+ as separate values, but any relations and lookups based on those values, once you enter them, will not distinguish them.

Of course, manually setting a value list to offer those four values is no big deal, and the value list does show up properly if manually configured. Yet if you want to *do* anything with those values, like look up percentages or colors, they won't work well...

However, a calculation can properly treat A+ and A differently:

Case(value="A+",99,value="A",95,value="B+",89,85)

So, if you manually configure your value list, then you can get another field to display a corresponding number, and do all relations (etc.) on the basis of the number rather than the mis-parsed text string.

-ESpringer

Set indexing option for source field to "ASCII"

Way to go man, you were right!

Thank's a lot, the ASCII index is the solution...

Something I discovered recently: setting indexing to ACSII has the side effect of making all find in that field case SENSITIVE. So a search for "dr" will not find "Dr" or DR" any more.

I would rather call it feature than "side" effect

Dj