AnsweredAssumed Answered

Find through a relationship established via global field

Question asked by mukai on Oct 4, 2018
Latest reply on Oct 4, 2018 by BruceRobertson

Hi everyone,


Ran in to a situation makes me feel like there are things I don't understand about Global Field.


See the attached file please.


If you run script 1 on the layout “Family”, I would expect to find only 1 record with family name of “Wallace1”.


But FileMaker instead gives me “Wallace1” and “Ferguson”.


Somehow is FileMaker ignoring the global field when it is used in establishing a relationship? therefore Find through that relationship is not operating as I (or we) would expect?


What is the rule here I shall remember about global? Or should I just not find related records via a relationship established via global field?


Scratching my head there is certain behaviour of Global Field I am unfamiliar with.


Much appreciated as always.