Has to be your data.
? would indicate something is wrong with it.
Have you confirmed that both fields are indexed, NAME is validated to require a unique value, and the ID is unique as well?
Both fields are indexed. Name is validated to require a unique value. ID was not set to unique but it is set up as a serial number. I set it to unique, as well, but that didn't change anything.
Go into Manage | Database and check the field type. I suspect your name field is declared as a field of type Number. This then changes how the values index and you get the result shown.
I SWEAR I checked the value to make sure it was Text but it wasn't. I had exported the 2 fields and it worked fine in a new solution so it was driving me crazy as to why it wasn't working in the other solution.
I have to have eye surgery next week so I'm blaming it on that.d
Thanks ever so much.