I’m sure you’re right that the code is not being inconsistent. It’s much more likely that the inconsistency is in my 10 year old, 25,000 record database.
However, there is a something weird going on and it’s not just different spellings thwarting the clairvoyance. I played with it more yesterday and found that when I ran across an instance where I thought the clairvoyance should be working but wasn’t (for example on a data entry where it had worked a few entries earlier), I could sometimes hand-type the entry, go on to another entry, then come back to the problematic one, delete the hand-entered data to retry it and the clairvoyance would work the second time.
Now, it’s quite possible this is due to some residual weirdness in the database itself. Maybe invisible characters in a field or extra spaces? Though I’d have no idea how they go there. Or some other minor corruption maybe.
It’s a minor annoyance, not a game stopper, so I can live with it for now. I can check to see if this is happening with other Panorama x files as well, old and new, or just this one, which would give a more definitive answer as to where the issue is, of course.