I could not replicate the problem from scratch based on the number 503101-4000001 ect.
Any chance that the source of the alien numbers were dragged/dropped or copy/paste from Excel or Word ?
Perhaps, there are some "invisibles" in the content.
Be sure all of your key fields, which you call "numbers" are stored as text data, otherwise the dashes may be ignored or, worse yet, treated as operator characters.
Thanks for the reply usbc.
No. Neither of the numbers were copied or pasted.
Invisibles is not an issue. Even when I delete both records and create new ones. When I use
503101-4000002 I have an relation and when I change in both records the last digit 2 in a 1.....gone.
I freaks me out:-(
Thanks for answering Stephen.
Of course the keys are stored as text. I wrote that it only appears in a few cases such as in my example.
Other records are showt perfectly.
In my administration I have a difference of 40.000 in the total cost of 26.000.000.
What worries me is that I can't rely on my FM database:-(
As you store each of the numbers separately can you make the relationship via the two values... not just one?