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.

 

regards,

Kevin

Outcomes