I have a key field which can store one or more values (multi line key), e.g.:
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?