I haven't seen this one in 20 years of using FileMaker.
I really hope you can help me out.
I use 2 tables with Pkey = number1 &"-"&number2 like this 503101-4000001.
When I use this key in both tables the relation is lost.
Any other number I use in both tables the relation is establised for example:
but when I change the last digit 2 in 1.....................relationship gone.
I have several numbers where this appears,
In the Ptabel with 1500 records about 15 numbers
I need this numbers for it is used as a cost-heading in our administration
Thanks for your ideas.
Message was edited by: glimmieglimbo I added an Word doc with screenshot so you can see what happens.