5 Replies Latest reply on Nov 26, 2013 7:37 AM by LyndsayHowarth

    Relationship lost......but why?

    glimmieglimbo

      Dear users/developers,

       

      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:

      503101-4

      503101-40

      503101-400

      503101-4000

      503101-40000

      503101-400000

      503101-4000002

       

      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

      Im confused.

       

      Any suggestions??

      Thanks for your ideas.

       

      Greetings,

      Martin

       

      Message was edited by: glimmieglimbo I added an Word doc with screenshot so you can see what happens.