AnsweredAssumed Answered

Multi Line Key and viewing matching values

Question asked by fmdataweb on Jul 27, 2016
Latest reply on Jul 27, 2016 by philipHPG

I have a key field which can store one or more values (multi line key), e.g.:

 

C100

C145

C765

 

I also display the name field for the matching parent record - I realise this can only display one at any time. I've noticed that it always displays the matching related value from the last value entered into the multi key field, e.g. in the above example it shows the match for C765.

 

I was hoping to always show the match for the first entered value, e.g. C100 in the above example. Does anyone know a way to force FileMaker Pro to show the matching value based on the first value in the multi line key?

 

Thanks

Outcomes