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.