AnsweredAssumed Answered

Relationship lost......but why?

Question asked by glimmieglimbo on Nov 25, 2013
Latest reply on Nov 26, 2013 by LyndsayHowarth

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.

Attachments

Outcomes